Question About Parsing JSON from SharePoint Connector

(0) Share

Report

Posted on by powerUser1611

119

Hi all- quick question.

I've been trying to get more comfortable manually parsing JSON outputs from action outputs and am trying to learn more about how to point to specific values for expressions.

For most outputs, it follows this format: Outputs('Action_Name')?['Object']?['Key']. However, when using the SharePoint connector, any reference to the 'body' follows this format: Outputs('Get_Items')?['Body/Object/Key'].

What are the difference between these two? What does the '/' do that the '[X]?[Y]' does not?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

@powerUser1611 ,

You could use either of the two expressions. Both should work.
The only difference that I found is that the output of the first expression returned a string whereas the latter returned a JSON.

My Sample:

The two expressions I used:

Expression:

Expression:

Was this reply helpful? Yes No
powerUser1611 119 on at

Like (0)

Report

@SudeepGhatakNZ That's really interesting, thanks for your reply.

Was this reply helpful? Yes No