Resolved! String value in list with options
I have a list with the following schema:I would like to have the dataType be a list of values to pick from when adding items to the list. How can I achieve this?
Forum Posts
Inject variable list of into a parameter.
I have a list of Ids in a variable:{ObjectTypes:[6,118,119]} want to have this injected into a JSON parameter for a JIRA API call{"qlQuery": "objectTypeId IN ()"}I tried using the variable between the () and it did not like the formula.The resulting ...
Alternate TCP Ports
Is there a way to use alternate ports for APIs? A customer has an API using a different port: https://xxx.company.com:8442.
Processing 100k records from csv file
Hello everyoneWant to process 100k records from csv file and dump them in a databasehere i'm getting below errorErrorJob has been shut down by the system. Usually it happens due to high memory consumption. Try reworking the recipe to process less amo...
SQL Server Polling Trigger Skips Records When Updates Occur During Processing
We are facing an issue with the SQL Server 5-minute interval polling trigger recipe.The trigger recipe is already in Started state. When we update a record in SQL Server, the job is picked up after some time and starts processing, which is expected....
Resolved! Handling Dynamic headers while composing a csv file
Hello all,Currently I have a crazy requirement where the headers of a csv file are dynamic, I noticed just now that I can't access any pills in formula mode in order to write a lookup formula for headers section in compose csv action.Currently the on...
Handing complex JSON objects
I have a need to read data from several sources and push that data into another API. The API input is the following schema:{ "matchOnName": true, "entities": [ { "id": "00000000-0000-0000-0000-000000000000", "entityFieldValues": ...
Schema friendly names
Is there a way to have Workato NOT show a friendly name for a schema. I have a recipe function that returns an object based on a schema and I would like to use that schema in the calling recipe as it was defined. For example, show "displayName" inst...
Resolved! Graph API Paging
I need to read a list of Managed Devices from Intune. This list returns just fine for the first set of results, but I do not see an option to use @odata.nextLink from the result. I saw an older thread needing a loop using @odata.nextLink, but I did...
Resolved! Recipe function return value from Parse JSON
I am creating a recipe function to return a result from an API call. I have a Parse JSON step, but how do I return the result of this was the output of the recipe function? I have the schema defined, but I cannot get a datapill from the output of t...
