Jeez! Why is this so tough to get! 🙂
Need the 'results' array nested here:
{ "d": { "results": [ { "__metadata": { "id": "240b3a48-d569-4ba1-8bfe-698922ff05f1", "uri": "https://company.sharepoint.com/sites/test/_api/Web/Lists(guid'80cb32af-1111-47fd-9262-e2c47a82b400')/Items(10913)", "etag": "\"12\"", "type": "SP.Data.TestListItem" }, "Id": 10913, "ID": 10913 } ], "__next": "https://company.sharepoint.com/sites/test/_api/web/lists/GetByTitle('Test%20Users')/items?%24skiptoken=Paged%3dTRUE%26p_ID%3d10913&%24select=ID&%24top=1&%24orderby=ID+asc" } }
Specifically, just the "ID" value.
Solved! Go to Solution.
body('Parse_JSON_2')?['d']?['results']?[0]?['ID']
U were very close 🙂
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I feel like one of these should work, but they don't:
Output is blank for these
Entire json payload is returned from this
Error for this: 'body('Parse_JSON_2')?['d']?['results'][1]' cannot be evaluated because array index '1' is outside bounds (0, 0) of array. Please see https://aka.ms/logicexpressions for usage details.'.
body('Parse_JSON_2')?['d']?['results']?[0]?['ID']
U were very close 🙂
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Arrays begin with index 0 always
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
You're a good man @RezaDorrani ! Thank you.
Do you know why...
Hi @ericonline
body('Get_Sharepoint_List_Using_HTTP')?['d']?['results']?[0]?['Title']
body('Get_Sharepoint_List_Using_HTTP')?['d']?['results']?[0]?['internalcolumnname'] - format will give you the data for any column in the first item of the results array
Can you elaborate your question futher with screenshots please
Scenario:
I'd like to skip the Parse JSON step by using the expression body('Send_HTTP_Request_to_Sharepoint')?['d']?['results']?[0]?['Column1']?['Column2']?['ColumnN'] directly in the File Content area of Create File action.
Unfortunately, the file is always blank when I attempt this. I have to use outputs('Parse_JSON') to create the file.
Here is the schema from Get full list:
{ "statusCode":200, "headers":{ "Transfer-Encoding":"chunked", "Vary":"Accept-Encoding", "X-SharePointHealthScore":"0" }, "body":{ "d":{ "results":[ { "__metadata":{ "id":"1111-236a-1111-9aeb-dc020c8ee4b6", "uri":"https://mycompany.sharepoint.com/sites/test/_api/Web/Lists(guid'1111-c27a-4de7-1111-3b743548dd11')/Items(1884)", "etag":"\"17\"", "type":"SP.Data.test" }, "Column1":1884, "Column2":null, "Column3":null } ] } } }
I'd like to skip the Parse JSON step...
But when I try the body() expression shown above, the file is always empty.
Hi @ericonline
body('Get_Full_List')?['body']?['d']?['results']?[0]?['Column1']
body('Get_Full_List')?['body']?['d']?['results']?[0]?['Column2']
body('Get_Full_List')?['body']?['d']?['results']?[0]?['Column3']
if u need the uri then
body('Get_Full_List')?['body']?['d']?['results']?[0]?['__metadata']?['uri']
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
35 | |
15 | |
14 | |
13 | |
9 |
User | Count |
---|---|
42 | |
30 | |
26 | |
14 | |
12 |