Chain json results as string

[phil]

A module return a json payload with a X number of results, like

values > 0 > 0 Apple
values > 1 > 0 Orange
values > 2 > 0 Pear

and I need to generate a multi-line string like

Apple
Orange
Pear

Which is the best way?

 

[Neeraj]

A module return a json payload with a X number of results, like

values > 0 > 0 Apple
values > 1 > 0 Orange
values > 2 > 0 Pear

and I need to generate a multi-line string like

Apple
Orange
Pear

Which is the best way?

Do you have fix amount of results every time or do they keep on changing?

 

[phil]

Keep changing, otherwise it would be easy

 

[Neeraj]

Keep changing, otherwise it would be easy

Can you change your incoming payload from the source?

Add a new key will All the values in it?

Otherwise, I am out of ideas. Maybe someone else can pitch in.

 

[PabblyMember3]

A module return a json payload with a X number of results, like

values > 0 > 0 Apple
values > 1 > 0 Orange
values > 2 > 0 Pear

and I need to generate a multi-line string like

Apple
Orange
Pear

Which is the best way?

Can you try to get the above data not as a simplified response and then, pass the value array to JSON extractor to get the values as shown below:

And then you can replace comma from the data > all with <br> in the next step using Text Formatter - Replace Text action to get the desired values.

 

[phil]

Yes it's troublesome.
Please consider adding a variable module in PC, that allows iterations.
That would make operation more simple and wouldn't need multiple steps.

This would be easy like

foreach ($module_result as $value) {
$value = $value & "\n";
}
return $value


I will check the Naveen solution

 

[phil]

In my case Naveer solutionwon't work.
I get the values from the Google Sheet module

Markup 2021-04-16 at 12.50.16.png

Shared with Droplr

punto-rosso.d.pr

so I cannot use the Json extractor to get all values

 

[PabblyMember3]

In my case Naveer solutionwon't work.
I get the values from the Google Sheet module

Markup 2021-04-16 at 12.50.16.png

Shared with Droplr

punto-rosso.d.pr

so I cannot use the Json extractor to get all values

Hey Phil,

Just turn of the simple response and send the test request in the Google Sheet step, you will get the values as an array and map the same in the JSON extractor field, you will get the response with comma separated values

 

[phil]

If I turn off the simple response on the Google Sheet step the Json extractor don't deliver the ALL value

Markup 2021-04-16 at 14.22.50.png

Shared with Droplr

punto-rosso.d.pr

 

[PabblyMember3]

If I turn off the simple response on the Google Sheet step the Json extractor don't deliver the ALL value

Markup 2021-04-16 at 14.22.50.png

Shared with Droplr

punto-rosso.d.pr

Could you please share your Workflow URL, I need to check that.

 

[phil]

I have created a simpler one, for you to test

Pabbly

connect.pabbly.com

 

[PabblyMember3]

I have created a simpler one, for you to test

Pabbly

connect.pabbly.com

Thanks for sharing the workflow.

I can see, there are nested square brackets causing the problem, but, I have made some changes to make it work.

I have added a couple of Text Formatters - Replace Text to replace [" and "] with " (double quotes) to get the final array like ["val1","val2"].

Please check the attachment and your workflow. Now, you can get the comma separated values.

I hope you find it helpful.

 

[phil]

Thanks for your help, Naveen.
That's the same solution I am using in my workflow, but doesn't look a bit....weird?
Especially when you have different logical mappings, it looks like a maze in a jungle
A text filter, that allows only certain characters to go trough (ex. A-Z, 0-9), would be a great help.
Not perfect, but "clean", at least.

 

[phil]

By the way, if you use multiple Text Replace module, you won't even need the json extractor.
Simply replace all ", [ and ] and you get a value1,value2 string

 

[PabblyMember3]

By the way, if you use multiple Text Replace module, you won't even need the json extractor.
Simply replace all ", [ and ] and you get a value1,value2 string

I can understand, unfortunately, multiple replacements in a single step are not possible. For now, you can use the Text Replace step one by one for doing the same.

 

[phil]

Ok, noted. Thanks for your help.