I’m working on a solution which needs to lookup a unit price from an API call. The JSON returned by the API call includes an array of Prices in the following format:starting_quantityending_quantityunit_price11009.991012008.99200NULL7.99I have a Quan...
HiAnother simple question that I just can't seem to figure out I have a Recipe that currently triggers when a new (single) record is (manually) created in a Data Table. And it works very nicely.I want to modify the solution to handle multiple rows ...
Hello Forum PeopleSo, I’ve got a STRING value of… "26/03/26 14:51:06" from one system that I need to convert to a date for use when making an API call to another system. According to the Workato documentation the .to_date() function is what I want.T...
HiI was excited to find an EXACT match for my issue (as per the Subject Line) right here... it's just that the response didn't give me enough to get started I have a SaaS system to which I can subscribe to webhooks. But there will be a variety of d...
HiI'm using Data Tables to cache data whilst integrating two systems, in order to both reduce the number of API calls I'm making and also to provide an audit trail of actions being made, to help out whoever has to support the delivered solution in fu...
Hi GarySample JSON of the array of Prices looks like this..And slightly bigger screenshot of the formula looks like this...Appreciate your time (as always) and confirmation that there's nothing readily apparent as an alternative besides writing a cod...
Hmmm... looks like I had failed to specify an option for the "Choose the desired output format" field on the trigger!This was initially left blank when the trigger was changed. When I chose (either) value from the drop-down I can now see the expecte...
Hey GaryThanks for your replies (as always)!I completely understand that any system when faced with a two digit year has to make assumptions. And (especially since the fuss around Y2K) we all know how bad that can be. But the documentation tells me...
OK, so the bit I was missing was how to get a handle on the basic Payload in the trigger.The key piece of missing knowledge was simply to switch the Document field of the JSON Parser into Formula Mode and then use .to_json on the Payload value from t...
Hi GaryI understand every single word in your replies (and really appreciate your time and assistance!)... it's just that I still can't see how to proceed I've got a Recipe that receives the webhook call. The idea is that this will just then effect...
