Page Comparison

...

Info

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 {access-key} is provided by Boxalino.

It is only valid for this service.

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

...

Info

There should be configurations in the input_data_feeds view from <account>_views dataset.
Use the <endpoint>/loadfeed/{access-key}?name=<feed-name> action in order to validate your configurations.

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	/loadfeed/{access-key}?name=<feed-name>
2	Method	POST \| GET

...

Info

There should be configurations in the google_sheet_data_feeds view from <account>_views dataset.
Use the <endpoint>/googlesheetfeed/{access-key} action in order to validate your configurations.

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	/googlesheetfeed/{access-key}?name=<feed-name>
2	Method	POST \| GET

Tip
Once the views is configured, the files will get loaded per desired frequency (as configured).

Adding a new googlesheetfeed configuration model

Info

As an integrator, check that you have write permissions to the <client>_views dataset in order to continue:

Go to Google Cloud BigQuery and run the SQL:
SELECT * FROM `bx-bdp-53322.<BOXALINO ACCOUNT NAME>_views.google_sheet_data_feeds`

In case you do not have permissions, contact Boxalino on slack or via email datafeed@boxalino.com

The googlesheetfeed configuration model is defined in the google_sheet_data_feeds view in the client`s account dataset.

Code Block

SELECT
'<FEED NAME>' as name
, '<ID of the google sheet>' AS id
, '<A1:D50>' AS sheet_range
, ';' AS field_delimiter
, 'CSV' AS format
, '<BOXALINO ACCOUNT NAME>_core' AS destination_dataset
, '<TABLE NAME>' AS destination_table
, true AS autodetect
, '<SCHEMA (string or JSON) IF autodetect=false>' AS schema
, 1 AS skipRows
, 0 AS max_bad_records
, '' AS quote
, 'WRITE_TRUNCATE | WRITE_APPEND' AS write_disposition
, '' AS create_disposition
, '' AS encoding
, '<CRONJOB CONFIGURATION FOR LOADING FILES, EX: 20 12 * * *>' AS cronjob
, 'googlesheet' AS type

...

Versions Compared

Old Version 19

New Version 20

Key

Adding a new googlesheetfeed configuration model