topic Re: Building a Body with multiple records (Batch) in Workato Pros Discussion Board

Building a Body with multiple records (Batch)

emorera — Mon, 29 Aug 2022 15:51:59 GMT

Hi there, I am new in this community so to Workato. I am looking for building a Body requests using multiple records (batch), I have a Workato list created but I don't know how to build this body call. Here is a sample

Re: Building a Body with multiple records (Batch)

david-macintosh — Mon, 29 Aug 2022 19:47:25 GMT

Hi Eric, I think you will need to provide more context. Can you show the section of the recipe that contains the connector action?

Re: Building a Body with multiple records (Batch)

jblanchett — Mon, 29 Aug 2022 20:12:19 GMT

If you’re looking to send this list in a request to another app, start by adding an action step to do that. If you’re using one of workatos connector or SDKs you can map fields from your list into that step. If you’re hitting an app with no connector available, you’ll need to build the request schema in a HTTP action step first but then do the same thing

Re: Building a Body with multiple records (Batch)

emorera — Mon, 29 Aug 2022 21:31:18 GMT

Thank you for your response, will this work? I am not sure this will work...Joseph Blanchett , David MacIntosh

Re: Building a Body with multiple records (Batch)

jblanchett — Mon, 29 Aug 2022 21:45:40 GMT

Ah, I see. I typically will use a common data model to define the HTTP Request JSON Schema. You can use the MAPPER action in workato to map your list data to the common data model. Unless the list is EXACTLY the format your HTTP Request is in, you can map the list directly into the HTTP Action directly. Here is an example.

Re: Building a Body with multiple records (Batch)

emorera — Mon, 29 Aug 2022 22:01:59 GMT

Joseph Blanchett will this allow to make a Batch request to the App? I want all records of the list to be included into the same call.

Re: Building a Body with multiple records (Batch)

jblanchett — Mon, 29 Aug 2022 22:02:49 GMT

Yes just create your common data model schema contain a list

Re: Building a Body with multiple records (Batch)

emorera — Mon, 29 Aug 2022 22:03:38 GMT

Perfect, I will try and let you know, thanks!

Re: Building a Body with multiple records (Batch)

david-macintosh — Mon, 29 Aug 2022 22:11:47 GMT

Do you have an example body structure that is expected from the API call you will be making via HTTP? This is important to accuracly advise. In many cases you would use a message template for the body itself and would start with the example API body for creating it. In terms of batch support, again that will depend on the structure of the anticipated message to the API. It it accepta a list then the acculation to list variable works assuming there is a coresponting list structure in the messge to map to. If it accepts a single record than a batch connector call inside an iteration loop could be the way to go.

Re: Building a Body with multiple records (Batch)

emorera — Mon, 29 Aug 2022 22:13:49 GMT

Yes, here it is, that is two items:

{

"upload_request_id":"b3eb858c-e880-4938-bba3-bd5b733dd9b5",

"records":[

{

"phone_numbers":[

{

"phone_number":"+351929312312",

"phone_type":"MOBILE"

}

"first_name":"Joey",

"last_name":"Tribbiani",

"timezone":"Europe/Lisbon",

"priority":7,

"extra_data":{

"country":"USA",

"state":"California",

"job":"Actor"

}

{

"phone_numbers":[

{

"phone_number":"+351929312313",

"phone_type":"MOBILE"

}

"first_name":"Jane",

"last_name":"Doe",

"timezone":"GMT",

"priority":5,

"extra_data":{

"country":"USA",

"state":"California",

"job":"Actress"

}

]

}

Re: Building a Body with multiple records (Batch)

david-macintosh — Mon, 29 Aug 2022 23:02:55 GMT

So you could have "records" list in your datamodel and map your accumlated list variable datapill to it. If you use a message template you would have somehting like:

{

"upload_request_id":"b3eb858c-e880-4938-bba3-bd5b733dd9b5",

"records":{{Records}}

}

And would have map point of Records to map to in formula mode as datapill.to_json

Re: Building a Body with multiple records (Batch)

bennett-goh — Tue, 30 Aug 2022 10:13:49 GMT

Hi Eric! Are you using the connector SDK to build this body or the HTTP connector?