API Return data from a region Returning Error 404
Con rispostaHello 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 have extended my API call to read the specific content, so my new URL is : https://api.app.wdesk.com/platform/v1/spreadsheets/009cbcf44dd44bf686027392acc39c73/sheets/3f2e9b611af240208b3f9b937f292b5a/data/A1
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?
-
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
Thanks ffor a quick turnaround, it was quick and it worked. Not sure why documentation is misleading .
0
Glad it worked!
Here's the correct documentation for that endpoint showing use of `values`: https://developers.workiva.com/workiva-platform/reference/platform-getvaluesbyrange0
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
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:0
Wonderful. Tha worked!!! Thank you so much. really appriciate your help
0Accedi per aggiungere un commento.
Commenti
6 commenti