topic Can anyone identify why i cant map from my nested list in Workato? in Workato Pros Discussion Board

Can anyone identify why i cant map from my nested list in Workato?

ryan-avent — Tue, 30 Aug 2022 22:49:06 GMT

I have an array called records and this contains an array called actions to be mapped to an API response, i have mapped the records source list correctly but when selecting the actions source list i am not given the ability to map the actions datapil.

Re: Can anyone identify why i cant map from my nested list in Workato?

jblanchett — Tue, 30 Aug 2022 22:51:50 GMT

Try re-saving/refreshing the schema in step 8 then attempt to map it in again.

Re: Can anyone identify why i cant map from my nested list in Workato?

ryan-avent — Tue, 30 Aug 2022 23:09:01 GMT

Joseph Blanchett tried that sadly same issue, seems to be the case a bunch of other recipies aswell where ever i have an array that contains an array workato wont recognize the child, i must be doing somthing wrong somewhere as this is a basic requirment for message processing.

Example Schema:

[

{

"control_type": "number",

"label": "Object ID",

"parse_output": "float_conversion",

"type": "number",

"name": "objectId"

{

"control_type": "text",

"label": "Title",

"type": "string",

"name": "title"

{

"control_type": "text",

"label": "Link",

"type": "string",

"name": "link"

{

"control_type": "text",

"label": "Quote name",

"type": "string",

"name": "quoteName"

{

"control_type": "text",

"label": "Valid",

"type": "string",

"name": "valid"

{

"control_type": "text",

"label": "Amount",

"type": "string",

"name": "amount"

{

"name": "actions",

"type": "array",

"of": "object",

"label": "Actions",

"properties": [

{

"control_type": "text",

"label": "Type",

"type": "string",

"name": "type"

{

"control_type": "text",

"label": "Confirmation message",

"type": "string",

"name": "confirmationMessage"

{

"control_type": "text",

"label": "Confirm button text",

"type": "string",

"name": "confirmButtonText"

{

"control_type": "text",

"label": "Cancel button text",

"type": "string",

"name": "cancelButtonText"

{

"control_type": "text",

"label": "Http method",

"type": "string",

"name": "httpMethod"

{

"control_type": "text",

"label": "URI",

"type": "string",

"name": "uri"

{

"control_type": "text",

"label": "Label",

"type": "string",

"name": "label"

{

"control_type": "number",

"label": "Width",

"parse_output": "float_conversion",

"type": "number",

"name": "width"

{

"control_type": "number",

"label": "Height",

"parse_output": "float_conversion",

"type": "number",

"name": "height"

}

]

}

]

Re: Can anyone identify why i cant map from my nested list in Workato?

ryan-avent — Tue, 30 Aug 2022 23:25:15 GMT

looks like Workato has a bug (tested in chrome) the page forsnt allow you to select the datapil for the array (doesnt allow you to select) but iy you hightlight the text and drag it to the source list then it works.

Re: Can anyone identify why i cant map from my nested list in Workato?

iwhitman — Wed, 31 Aug 2022 01:33:30 GMT

Can you share the raw data (JSON or XML or otherwise) that mapped into the datapills shown in the screenshot?

Re: Can anyone identify why i cant map from my nested list in Workato?

miki-matsumoto — Wed, 31 Aug 2022 07:25:30 GMT

A workaround to select datapill is to switch the mode of the textbox from text to fomula.

Re: Can anyone identify why i cant map from my nested list in Workato?

gwilkinson — Wed, 31 Aug 2022 19:46:43 GMT

Agree with Ryan about the work around. Double click the pill of the nested item/field and then drag it over to map it.

Re: Can anyone identify why i cant map from my nested list in Workato?

rachelnatik — Wed, 31 Aug 2022 21:05:14 GMT

What they all said,. Try highlighting it, and dragging it,

Re: Can anyone identify why i cant map from my nested list in Workato?

ab — Tue, 06 Sep 2022 03:33:46 GMT

Hi Ryan,

Sorry for the late reply.

Please try 'Group mapping' option (it's in the upper-center-right on your screenshot). This always work for the nested lists.

Re: Can anyone identify why i cant map from my nested list in Workato?

mkumar7 — Tue, 06 Sep 2022 12:03:22 GMT

Hi Ryan,

If you look at the Record list that you have at step 8, there is a Record datapill as an array type in the root level.

So, you have to use a for each step on the Record datapill and bring the "Return Success" step inside the for each step.

Now, you should be able to select the first nested level of array datapills(Actions, in your case).

Hope, this helps!

Re: Can anyone identify why i cant map from my nested list in Workato?

ab — Tue, 06 Sep 2022 16:32:17 GMT

It's possible to map any nested level with 'Group mapping' function. Please kindly see my reply above.

Re: Can anyone identify why i cant map from my nested list in Workato?

gwilkinson — Tue, 06 Sep 2022 18:57:38 GMT

Ah, didn't know that. Will have to try that. Thx

Re: Can anyone identify why i cant map from my nested list in Workato?

gwilkinson — Tue, 06 Sep 2022 18:59:21 GMT

Nice tip, I will need to try your suggestion. Thx