Map & split JSON (into D365FO)

(0) Share

Report

Posted on by PowerA_rookie

Hi Experts!

Disclaimer, as the names states, I'm enthusiastic but quite new to Power Automate.

I'm trying to import the following JSON into D365FO:

www.floatrates.com/daily/dkk.json

Though, I am having a tough time mapping the data correct. I have no problems in parsing the JSON in the Schema:

But from there on and onwards, I guess I need to split the currencies into separate lines since it's still in one big string. At least, that is what I understand, cause whether I try to compose the output of i.e. USD, I do not get to map and create the records as the right currency.

I've tried to use the split function as well, where I split the Output at every '},', but without luck. I'm not a developer, so if you know how I can split this JSON correctly, please let me know!

Best regards,

PowerA_rookie

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report
Here is one way to reference the properties of each currency.

I want the currency info for the following: USD and GBP

This is the Schema for the Parse JSON action:
{ "type": "object", "properties": { "code": { "type": "string" }, "alphaCode": { "type": "string" }, "numericCode": { "type": "string" }, "name": { "type": "string" }, "rate": { "type": "number" }, "date": { "type": "string" }, "inverseRate": { "type": "number" } } }
The Schema for the Parse JSON action was generated using the following sample data:
{ "code": "USD", "alphaCode": "USD", "numericCode": "840", "name": "U.S. Dollar", "rate": 0.15263770234795, "date": "Wed, 16 Feb 2022 11:55:01 GMT", "inverseRate": 6.5514613009597 }

Sample runtime output for two currencies:

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
PowerA_rookie 34 on at

Like (0)

Report

Thank you for the detailed reply.
I got the reply and result I wanted and my flow seems to be working correctly.

Was this reply helpful? Yes No