Finance | Project Operations, Human Resources, ...

Parse JSON is what actually does in file based integration in D365F&O

(0) Share

Report

Posted on by CU05031448-0

809

Dear team,

I used and saw the Parse JSON while we are working with Recurring file based integration in Logic Apps.

What I understood, the JSON file which we received from third party application. We first stored into Azure blob storage and from the Azure blob storage we download the file.

Then we use PARSE JSON to read and extract the value from the file.

Through the process of PARSE JSON, we also received the EXECUTION ID, which we can used later to get the Execution summary status.

Is my assumption is correct?

Please advise.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 236,570 Most Valuable Professional on at

Like (0)

Report

Parse JSON is what actually does in file based integration in D365F&O

No, it doesn't sound correct.

When you receive JSON, you can work with it, such as parsing it. You don't have to upload it to a blob and download it again; that would just give you what you already had before the upload.

Also, parsing a JSON file has nothing to do with an execution ID and execution status. There you seem to be talking about an F&O data management API, not JSON parsing.

Was this reply helpful? Yes No
CU05031448-0 809 on at

Like (0)

Report

Parse JSON is what actually does in file based integration in D365F&O

Thanks Martin,

I understood well the second paragraph.

In first paragraph as mentioned "When you receive JSON, you can work with it, such as parsing it."

What is parsing? I mean suppose I have received the JSON file and we parsing it.

What is mean that? I mean what it does wth file after parsing.

Kindly advise pls.

Thanks!

Was this reply helpful? Yes No
Anthony Blake 2,823 Super User 2025 Season 2 on at

Like (0)

Report

Parse JSON is what actually does in file based integration in D365F&O

Hi @CU05031448-0

Parsing is just the process of readying the Json and extracting the information you want from it.

Are you trying to figure out an existing Logic App here and how it works? Why not share some of the details (e.g. redacted screenshot) and we can help you with specifics?

Thanks

Anthony

Was this reply helpful? Yes No
CU05031448-0 809 on at

Like (0)

Report

Parse JSON is what actually does in file based integration in D365F&O

Thanks Anthony, I will try to share it.

Actually from the client VM and as per the company policy they disabled the screenshot. Thats the reason I couldn't share it...

I explained here...

I create a folder like Inbound on Azure Blob storage.

In Logic app

Step 01 - Initialized the variables like Tanent I'd, Application id, secret key etc

Step 02 - Download the file from Azure blob storage

step 03 - Parsing the JSON file.

Step 04 - Post call for Enqueue

Step 05 - With the execution id, check the Execution summary status.

Am I correct with the process.

Kindly advise pls.

Thanks!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Parse JSON is what actually does in file based integration in D365F&O

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Parse JSON is what actually does in file based integration in D365F&O

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates