To migrate your application to REST API v2, you need to update base URL for REST API endpoints in your application from https://<your-integration-URL>.caspio.com/rest/v1 to https://<your-integration-URL>.caspio.com/rest/v2.
For example, if you used https://<your-integration-URL>.caspio.com/rest/v1/tables in your application, you will need to update it to https://<your-integration-URL>.caspio.com/rest/v2/tables.
Additionally, there are other changes to query parameters and endpoint URLs in REST API v2 as described below.
- Changes in DataPage endpoints – DataPage endpoints is now grouped together with Application endpoints.
- Changes in Table and View endpoints:
- rows was changed to records (e.g. rest/v1/tables/{tableName}/rows is now rest/v2/tables/{tableName}/records)
- columns was changed to fields
- Changes in JSON encoded query string parameter (q) to individual query string parameters
- In REST API v1 q={“select”:”fields list”,”where”:”WHERE condition”,”groupby”:”grouping fields list”,”orderby”:”ordering fields list”,”limit”:<rows count>,”pageNumber”:<page number>,”pageSize”:<rows per page>}
- In REST API v2 q.select=<fields list>&q.where=<WHERE condition>&q.groupBy=<grouping fields list>&q.orderBy=<ordering fields list>&q.limit=<rows count>&q.pageNumber=<page number>&q.pageSize=<rows per page>