CODEWITHSUNDEEP
smartsheet-apismartsheet-api-2.0
Anil
Anil

Reputation: 1857

Is there any way to get smart sheet rows based on column value

I want to use smart sheet api to read sheet data. my sheet has changedtm column. I want to fetch rows which are greater than certain date. is there any way to do this using smart sheet API

Upvotes: 0

Views: 936

Answers (1)

daveskull81
daveskull81

Reputation: 637

You can't do this kind of filtering via the Smartsheet API exactly. One approach would be you could do a GET Sheet request and use the columnIds query string parameter to provide the id number of the specific column you are looking to review. Then you would get back a response that only contained data for that specific column. The filtering based on the date values would then have to be done by you in your code.

If you will need other data in the rows I would then just do the GET Sheet request to get all of the data in the sheet and do the filtering of the response in your code.

Upvotes: 1

Related Questions