Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 (,)

Define a different separator for the .csv file ( tab, pipe (|), etc). One character only!

NOTE: the default will be upgraded to “tab” in order to allow a list of data for value (ex: multivalue fields)

4

format

Default: csv

Change the format of export (ex: txt)

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
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

...

In order to use CSV headers with spaces, the _S_ can be used within SQL select field names.

VIEW GOOGLEADSFEED REQUEST

There should be a process within clients' own project that accesses the data from the /view/googleadsfeed/{access-key} service. Final format is CSV file, to be downloaded.

The
Info
Note

Parametrized queries are supported (https://cloud.google.com/bigquery/docs/parameterized-queries ). Simply use '@<key>' in the SQL and add the same parameter to the feed URL.

NOTE: all parameter values are casted as STRING.

VIEW GOOGLEADSFEED REQUEST

Info

There should be a process within clients' own project that accesses the data from the /view/googleadsfeed/{access-key}is provided service. Final format is CSV file, to be downloaded.

The {access-key} is provided by Boxalino.

It is only valid for this service.

...

Endpoint

https://boxalino-winning-interactions-krceabfwya-ew.a.run.app

1

Action

/json/{access-key}?name=<feed-name>

2

Method

POST | GET

3

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.

The JSON feed rely on the presence of a source in the <client>_views dataset in BigQuery.

GOOGLE SHOPPING FEED REQUEST

As an integrator, please create the bellow request to the provided endpoint.

...

There should be a process within your own project that accesses the data from the /googleshoppingfeed/{access-key} service.

...

It is only valid for this service.

Endpoint

https://boxalino-winning-interactions-krceabfwya-ew.a.run.app

1

Action

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 '@<key>' in the SQL and add the same parameter to the feed URL.

NOTE: all parameter values are casted as STRING.

GOOGLE SHOPPING FEED REQUEST

As an integrator, please create the bellow request to the provided endpoint.

Info

There should be a process within your own project that accesses the data from the /googleshoppingfeed/{access-key}

...

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

...

service.

Final format is tab delimited .txt (per Google Shopping Feed requirements). The data is formated based on Google Shopping Feed rules: https://support.google.com/merchants/answer/7052112

The {acces-key} is provided by Boxalino.

It is only valid for this service.

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
Basic base64<<READ API key : READ API Secret>>

note: use the API credentials from your Boxalino account that have the PUBLIC_READ assigned

Image Added

*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 <client>_views dataset (as defined in the {access-key} configuration)

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 '@<key>' in the SQL and add the same parameter to the feed URL.

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.

...