Get Rows API

The Get Rows API allows you to retrieve data from any data source with advanced filtering, ordering, and transformation capabilities. This endpoint uses POST method to support complex filtering parameters in the request body.

Endpoint

Method: POST
URL: {{data-core-svc-url}}/v3/orgs/{orgId}/data-sources/{dataSourceId}/rows

Request Parameters

Path Parameters

Query Parameters

Response

Success Response (200 OK)

Response Fields

Examples

Basic Query with Pagination

Pagination

The API supports two pagination methods:

1. Offset-based Pagination
   Use pageNumber and pageSize query parameters:

2. Cursor-based Pagination
   Use bqPageToken from previous response:

Best Practices

Use Appropriate Page Sizes: Start with 100-500 rows. Larger page sizes may timeout.

Use Cursor Pagination: For large datasets, cursor-based pagination (bqPageToken) is more efficient than offset-based.

Index-Friendly Ordering: Order by indexed columns when possible for better performance.

Handle Complex Types: Use stringifyComplexTypes=true for easier processing of arrays and objects.

Rate Limits

Maximum 1000 rows per request

Maximum 100 requests per minute per organization

Complex queries may have additional processing time limits