Unanswered

Decode JSON with null vaules from OneDrive for Business and import data to CDS

(0) Share

Report

Posted on by MichalB_106

Hello community, I have a problem with parsing JSON file, which is stored on OneDrive for Business. I have created a flow with Compose base64ToString(triggerBody()? function to decode json file.

However the .json file contains some null values and Compose gives me back an error message that values must be string not null. How can I solve this problem? All .json files, which will send to OneDrive from OCR app will contain some null values.

Thanks a lot for your advice.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Sumen Subramaniam 26 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Have you tried Parse Json to decode it?

Was this reply helpful? Yes No
Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
When you use the Parse JSON action to create a schema it automatically sets the type for String fields to string. But if the field can be null then you need to make two changes to the default schema. First, for any property that can be null you need to change the type from

"type": "string"

to

"type": ["string", "null"]

You should also check if that property is listed in the "Required" section. If it is then remove it.

Was this reply helpful? Yes No
MichalB_106 6 on at

Like (0)

Report
Copy link

Link copied!

Hello, thanks a lot for your answers. Finally the problem was in OneDrive, not in Flow.

Was this reply helpful? Yes No