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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
34 | |
15 | |
15 | |
13 | |
7 |
User | Count |
---|---|
41 | |
31 | |
25 | |
12 | |
12 |