API Return data from a region Returning Error 404

Udzielono odpowiedzi

Zamów wersję demonstracyjną

Hello Team,

I am calling API “ Return Data From a Region” API using Postman. So basically I have a sample spreadsheet on the workspace where I have read only permissions and I am trying to read the content of the spreadsheet using Postman, so what’s happening is - When I prepare my API URL till the spreadsheet sheet id( https://api.app.wdesk.com/platform/v1/spreadsheets/009cbcf44dd44bf686027392acc39c73/sheets/3f2e9b611af240208b3f9b937f292b5a it returns me success response :

{

"id": "3f2e9b611af240208b3f9b937f292b5a",

"name": "Note Outline",

"parent": null,

"index": 1,

"children": [],

"dataset": null

}

It is not returning any data out of that spreadsheet, however it has data in those sheets .

i.e., adding the range of cell ( I tried A1 : A2, OR just : and many more variations), service returns me back “404 No Found”.

Can you please suggest what am I missing here?

Komentarze

Komentarze: 6

Colleen Hardie

31/07/2023 17:46
Hi! It looks like you just need to update `data` in your updated URL to `values`. So:

https://api.app.wdesk.com/platform/v1/spreadsheets/009cbcf44dd44bf686027392acc39c73/sheets/3f2e9b611af240208b3f9b937f292b5a/values/A1

This is a difference between the older spreadsheets endpoints and the ones within the Platform API, so it's easy to get tripped up.
0
Harish Chhokra

31/07/2023 17:54
Thanks ffor a quick turnaround, it was quick and it worked. Not sure why documentation is misleading .
0
Colleen Hardie

31/07/2023 17:58
Glad it worked!

Here's the correct documentation for that endpoint showing use of `values`: https://developers.workiva.com/workiva-platform/reference/platform-getvaluesbyrange
0
Harish Chhokra

31/07/2023 17:59
one more question, how do I use Value_style, I would like an option to get calculated values in some instances and in other instances , i need raw data
0
Colleen Hardie

31/07/2023 18:03
You should be able to specify that as a query parameter to that endpoint. Something like the following:

https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}/values/{range}?$valuestyle=calculated

Or:

https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}/values/{range}?$valuestyle=raw
0
Harish Chhokra

31/07/2023 18:12
Wonderful. Tha worked!!! Thank you so much. really appriciate your help
0

Zaloguj się, aby dodać komentarz.