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)

Sumen Subramaniam 26 on at

Like (0)

Report

Hi,
Have you tried Parse Json to decode it?

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report
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

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

Was this reply helpful? Yes No