Grab information from a concat

(0) Share

Report

Posted on by Keavie

Hi All,

I want to get specific information from this line that I have concatted from a variable.

I want to get the information that is highlighted in this compose.

I have tried to split it but it doesn't seem to work.

Any assistance would be appreciated

[{"goods_id":"1305503d1b9252100a81848cd34bcba5","goods_description":"Bathroom Accessories Mirrors","package_marks":"ADDR"},{"goods_id":"6b05503d1b9252100a81848cd34bcbbf","goods_description":"Bathroom Accessories Mirrors","package_marks":"ADDR"}]

Thank you

Keavie

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Pacel1 79 on at

Like (0)

Report
Grab information from a concat

You can use "Parse JSON" action and use belowed code in schema

{ "type": "array", "items": { "type": "object", "properties": { "goods_id": { "type": "string" }, "goods_description": { "type": "string" }, "package_marks": { "type": "string" } } } }

After this You will be able to use goods_id property in next steps, for example select action :)

Was this reply helpful? Yes No
Keavie 20 on at

Like (0)

Report

Grab information from a concat

Hi Pacel1

I have tried this however it errors out when trying to do the Parse JSON,

Was this reply helpful? Yes No
Chriddle 8,416 Super User 2025 Season 2 on at

Like (0)

Report

Grab information from a concat

outputs('Compose')[0].goods_id

Was this reply helpful? Yes No
Pacel1 79 on at

Like (0)

Report

Grab information from a concat

Are You sure, You used my shema? In Your screen i can see that You used „Object” property, in my schema i used „Array”. Please check that again :)

Was this reply helpful? Yes No
Keavie 20 on at

Like (0)

Report

Grab information from a concat

I did try this and it only pulled through the first enter from the JSON. I need to get all the goods ID's as we can have up to 30 in this lookup.

I am doing a HTTP GET to get the Goods ID therefore when trying to Parse JSON it is failing when trying to do it as an Array.

Was this reply helpful? Yes No
Pacel1 79 on at

Like (0)

Report

Grab information from a concat

So try in different way :)

1. copy body outputs of your http request from your previous tests

2. go to edit flow

3. in parse json click generate from sample

4. paste in new window body of http request

5. click generate

6. test it again

Was this reply helpful? Yes No