Issue parsing a JSON file from OneDrive for Business

(0) Share

Report

Posted on by _jesan_

I'm having some issues trying to parse a JSON file from OneDrive for Business

My flow triggers when a new file is created (All files in the folder are json type).
I use the next JSON file

{"Prueba":"Hola mundo"}

I use the Compose action with the input (as indicated in this post=> Parse JSON file from OneDrive for Business) :

json(base64ToString(trigger()['outputs']['body']['$content']))

When I run the flow I get the next message:

Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2816': 'The template language function 'json' parameter is not valid. The provided value '{
"Prueba":"Hola mundo"
}' cannot be parsed: 'Unexpected character encountered while parsing value: . Path '', line 0, position 0.'. Please see https://aka.ms/logicexpressions#json for usage details.'.

I tried using the Parse JSON action having the same results

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @_jesan_

Could you please post a screenshot of your flow?

Thanks

Was this reply helpful? Yes No
Verified answer

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report
hi @_jesan_ maeby I did what you want

base64ToString(triggerBody()?['$content'])

result.

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (1)

Report

Hello @_jesan_

@ChristianAbata is correct, after doing the steps he posted. You can add another compose action and use the expression:
json()
And inside the () you can put the dynamic content of the base64 output.
Than run the flow, copy the output from the Json expression.
Now you can add a parse JSON action and use the copied value as the sample payload.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
_jesan_ 40 on at

Like (0)

Report

Hi, I tried your aproach but I get same results
Result:
I noticed there's difference in each output action result when JSON is involved.
It seems that when a output is identified as a valid JSON the pair "name:value" is shown with color, but when I use the first Compose action it seems that this colors are not shown in the same way.

Was this reply helpful? Yes No
Verified answer

_jesan_ 40 on at

Like (2)

Report

I've found the problem of the issue.
The program that creates JSON's files was using a utf-8 with BOM.
I created another file with flow and noticed this difference that file must be created with utf-8 codification.
Thanks four your replies.

Was this reply helpful? Yes No