Rearrange JSON output from HTTP Request

(0) Share

Report

Posted on by 55552

682

Is there a way to re-arrange the output from the screenshot below, coming from an HTTP request, to something like this?

{"issueID": "list the id associated with an issue",
"assetID": "list the corresponding id associated with the asset"},

{"issueID": "list the next id associated with an issue",
"assetID": "list the next corresponding id associated with the asset"}

Could this be done with a compose statement? I essentially need the id values from issue/asset pairs. The API returns the pairs, but an asset may be listed before OR after the corresponding issue.

I want each asset/issue pair grouped in a consistent manner, as shown above.

I am also able to get an array like this but would need a way to group every two rows together. (Rows 1 and 2 are a pair, Rows 3 and 4 are a pair). There could be many more than 4 rows, but would always be an even number, with adjacent items being pairs.

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Chriddle 8,713 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Just one Select:

From: @{outputs('Compose')}

Map issueId:

xpath( xml(json(concat('{"Root": {"Item": ', item(), '}}'))), 'string(//Item/entities[type="issue"]/id)' )

Map assetId:

xpath( xml(json(concat('{"Root": {"Item": ', item(), '}}'))), 'string(//Item/entities[type="asset"]/id)' )

Was this reply helpful? Yes No
Chriddle 8,713 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
If xapth looks too scary, you can also use this:

Map issueId:

if( equals( first(item()['entities'])['type'], 'issue' ), first(item()['entities'])['id'], last(item()['entities'])['id'] )

Map assetId:

if( equals( first(item()['entities'])['type'], 'issue' ), last(item()['entities'])['id'], first(item()['entities'])['id'] )

Was this reply helpful? Yes No
55552 682 on at

Like
a
(0)

Report
Copy link

Link copied!

I think your solution may work, but how should I dynamically get the asset and issue Ids?

{
"entities":[
{"type": "asset",
"id": 'id' //need to dynamically get the id associated with this (it is a guid)
},

Was this reply helpful? Yes No
Verified answer

Chriddle 8,713 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Simply put your array “relationships” into a Compose and use the Select below to retrieve them.

Was this reply helpful? Yes No