In order to assist with the Data Integration (DI) efforts with 3rd party systems (ex: Productsup, Google Shopping, Google Sheet, Google Ads, etc), Boxalino is presenting the Data Feeds services.
...
Endpoint | https://boxalino-winning-interactions-krceabfwya-ew.a.run.app | ||
|---|---|---|---|
| 1 | Action | /view/{access-key} | |
| 2 | Method | POST | GET | |
| 3 | Parameters (optional) | separator | Default: comma (,) |
| 4 | format | Default: csv | 5) |
| 5 | page | (optional) pagination; by default - all results are returned; | |
| 6 | limit | (optional) set a limit for number of rows per request by default - no limit; when used with page - default limit is 1000. | |
| 7 | Authorization | only if the key is for authenticated requests note: use the API credentials from your Boxalino account that have the PUBLIC_READ assigned  *Read more about credentials API Credentials | |
...
| Tip |
|---|
The data accessed is from a custom view in |
...
the |
In order to use CSV headers with spaces, the _S_ can be used within SQL select field names.
| Note |
|---|
Parametrized queries are supported (https://cloud.google.com/bigquery/docs/parameterized-queries ). Simply use |
VIEW GOOGLEADSFEED REQUEST
...
| Info |
|---|
There should be a process within your own project that requires the data from the project that requires the data from the The {access-key} is provided by Boxalino. |
Endpoint | https://boxalino-winning-interactions-krceabfwya-ew.a.run.app | |
|---|---|---|
| 1 | Action | /json/{access-key} |
...
The {access-key} is provided by Boxalino.
...
Endpoint
...
https://boxalino-winning-interactions-krceabfwya-ew.a.run.app
...
Action
...
/json/{access-key}?name=<feed-name>
...
Method
...
POST | GET
...
Authorization (header)
...
only if the key is for authenticated requests
Basic base64<<READ API key : READ API Secret>>
note: use the API credentials from your Boxalino account that have the PUBLIC_READ assigned
...
*Read more about credentials API Credentials
The data exposed in the data feed is in a JSON format.
...
?name=<feed-name> | ||
| 2 | Method | POST | GET |
|---|---|---|
| 3 | Authorization (header) | only if the key is for authenticated requests note: use the API credentials from your Boxalino account that have the PUBLIC_READ assigned *Read more about credentials API Credentials |
| 4 | Parameters (optional) | |
| 5 | page | (optional) pagination; by default - all results are returned; |
| 6 | limit | (optional) set a limit for number of rows per request by default - no limit; when used with page - default limit is 1000. |
The data exposed in the data feed is in a JSON format.
The JSON feed rely on the presence of a source in the <client>_views dataset in BigQuery.
| Note |
|---|
Parametrized queries are supported (https://cloud.google.com/bigquery/docs/parameterized-queries ). Simply use NOTE: all parameter values are casted as STRING. |
GOOGLE SHOPPING FEED REQUEST
...
Endpoint | https://boxalino-winning-interactions-krceabfwya-ew.a.run.app | |
|---|---|---|
| 1 | Action | /googleshoppingfeed/{access-key} |
| 2 | Method | POST | GET |
| 3 | Authorization (header) | only if the key is for authenticated requests note: use the API credentials from your Boxalino account that have the PUBLIC_READ assigned *Read more about credentials API Credentials : READ API Secret>> note: use the API credentials from your Boxalino account that have the PUBLIC_READ assigned *Read more about credentials API Credentials |
| 4 | Parameters (optional) | |
| 5 | page | (optional) pagination; by default - all results are returned; |
| 6 | limit | (optional) set a limit for number of rows per request by default - no limit; when used with page - default limit is 1000. |
| Tip |
|---|
The data accessed is from a custom view in |
...
|
In order to use CSV headers with spaces, the _S_ can be used within SQL select field names.
| Note |
|---|
Parametrized queries are supported (https://cloud.google.com/bigquery/docs/parameterized-queries ). Simply use NOTE: all parameter values are casted as STRING. |
LOAD FEED REQUEST
The LOADFEED service was created in order to load files directly into your project`s BigQuery ecosystem from Boxalino.
...