POST
Get Table Details
Retrieves detailed metadata of selected table.
Authorizations
Bearer Token required in header.
Authorization: Bearer <access_token>
Path Parameters
| Name | Type | Description |
|---|---|---|
| table_name | string required | The unique name for the table resource. Available tables: HR_Media_LOREAL, amz_dsp_campaign, amz_sads_campaign, internal Unif_Plat. |
Query Parameters
| Name | Type | Description |
|---|---|---|
| table_name | String | The table name. |
| desc | String | The table description. |
| total_rows | int | Number of rows (Table length). |
| schema | Object Array | Table schema. Array of field objects (name and data type) {'field_name':'','field_type':''} |
Request
curl -X POST \ "https://lorealconnexionmx.publicismedia.co/v1/getTableInfo" \ -H "Authorization: Bearer sk_live_..." \ -H "Content-Type: application/json" \ -H "Accept: application/json" \
-d '{
"table_name": "amz_dsp_productos"
}'
Status Codes
200 OK
Successful request. Returns table object.
404 Not Found
Table name does not exist.
400 Bad Request
Incorrect format of JSON or parameter values.
401 Unauthorized
Invalid or missing Bearer Token.
429 Too Many Requests
The maximum number of querys was exceeded (20 per hour).
POST
Get Data
Retrieves Data of selected table.
Authorizations
Bearer Token required in header.
Authorization: Bearer <access_token>
Path Parameters
| Name | Type | Description |
|---|---|---|
| table_name | string required | The unique name for the table resource. Available tables: HR_Media_LOREAL, amz_dsp_campaign, amz_sads_campaign, internal Unif_Plat. |
| columns | string Array | The columns that query returns. |
| start_date | Date | The start date of query (YYYY-MM-DD) [If use end_date the start date is used as "Between" funcion, if not use end_date start date works as >=] |
| end_date | Date | The end date of query (YYYY-MM-DD) [If use start_date the end date is used as "Between" funcion, if not use start_date end date works as <=] |
| page | int default: 1 | Page number for pagination (starts at 1). Use this to request specific data blocks. |
| page_size | int default: 200000, max: 200000 | Number of rows per page. Maximum 200,000 to protect server memory. If omitted, defaults to 200,000. |
Query Parameters
| Name | Type | Description |
|---|---|---|
| page | int | Current page number returned in the response. |
| page_size | int | Number of rows per page used in this query. |
| rows_returned | int | Actual number of rows returned in this page. If rows_returned < page_size, there are no more pages. |
| data | Object Array | Query results in object array ({'column_name':value}) |
Request
curl -X POST \ "https://lorealconnexionmx.publicismedia.co/v1/getData" \ -H "Authorization: Bearer sk_live_..." \ -H "Content-Type: application/json" \ -H "Accept: application/json" \
-d '{
"table_name": "amz_dsp_productos",
"columns": ["Campaign Name","Profile Id","Date"],
"start_date": "2025-11-10",
"end_date": "2025-11-15",
"page": 1,
"page_size": 200000
}'
Status Codes
200 OK
Successful request. Returns Data of selected table.
404 Not Found
Table name does not exist.
400 Bad Request
Incorrect format of JSON or parameter values.
401 Unauthorized
Invalid or missing Bearer Token.
429 Too Many Requests
The maximum number of querys was exceeded (20 per hour).