Hi,I need to create a nested json based on a SQL query.Sample dataset:Transportorder TO_param1 TO_param2 Ordernumber Order_param1 Order_param2 Orderitem Orderitem_param1OR-444450xyCO-12345xyCO-12345-1xOR-444450xyCO-12345xyCO-12345-2xOR-444450xyCO-123...
I'm querying a database from an API-Endpoint trigger and want to return the result as JSON.So far nothing out of the ordinary, and it works for other usecases.The data i do get back from the database though already contains a JSON string in one colum...
Hi,I used the "guided setup" but I cannot figure out how to add datapills to the "Request body parameters" it created. Below is how I configured using the Guided Setup:Setup OpenAI custom action from sample request Request type = JSON request body ...
Hi, In Wrike for Workato, Search projects action, how do you specify Metadata needed to limit the search? I am trying to limit the search by keyword in the Title. I get the following error if I specify 'Title' for Key and 'EOD' for value400 Bad Requ...
Hi there,I have a recipe that creates sales orders (header and lines) in Dynamics 365 F&O (ERP).I use a repeat for each action to create the sales order lines. The step input list is a list of the relevant line item data which includes a sequence num...
In Tibco Scribe we have a connector for Sage Intacct. To integrate invoices from CRM we use SOTransaction and SOTransactionItems objects. In the Workato-Sage Intacct connector, what are the corresponding APIs for SoTransaction and SoTransactionItem i...
Hi there, I'm getting an error from the get method in my connector when I try to get the response of a REST API method that returns binary data.The error is 783: unexpected token at '����' at line:I'm guessing it is trying to parse the re...
Happy to share a collection of links to resources for everybody who wants to become a Workato Connector SDK expert.This includes quick start guides, courses, training videos, reference libraries, example connectors, and in-depth guidelines for beginn...
I have noticed weird behavior recently. I was building a recipe and when I add "blank" word under the formula fields, that field will not sending to the endpoints.But with the latest updates, when I send the same content to different endpoints, it i...
So I am experimenting with bulk uploading to Creatio using a HTTP POST under Custom Action. I take a bunch of records and split them into batches and can succesfully loop through them. Through some editing I am able to get a variable resembling the b...
| User | Count |
|---|---|
| 146 | |
| 69 | |
| 48 | |
| 47 | |
| 36 |
