{"type":"doc","content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"Use this service to:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Export your data to other tools in your project (ex: productsup, google shopping feed, etc)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Accessing calculated data in a structured way (per request)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Load files directly to your GCP ecosystem (for order, customers enrichment)","type":"text"},{"type":"hardBreak"}]}]}]}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"This is service is currently expanding. We value our clients' feedback. ","type":"text"},{"type":"hardBreak"},{"text":"For further service requests and data feeds, please get in touch with Boxalino.","type":"text"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"57ab4c9b-0133-46a7-8fc2-b8f0647c1670"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"7e4ed406-f782-446f-afe2-d931374c9385"}},{"type":"heading","attrs":{"level":1},"content":[{"text":"GETTING STARTED","type":"text"}]},{"type":"paragraph","content":[{"text":"For any data required to be exposed (privately), follow the bellow steps:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Get in touch with Boxalino to receive ","type":"text"},{"text":"an access key","type":"text","marks":[{"type":"strong"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Communicate the purpose of the data feed & desired information ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"We will provide an access key ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Share ","type":"text"},{"text":"the access key","type":"text","marks":[{"type":"strong"}]},{"text":" with the integration team","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The integration team makes an HTTP request to access the data (per documentation bellow)","type":"text"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"READ FEED REQUEST","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"There should be a process within the client project that reads the data from the ","type":"text"},{"text":"/read/{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" service. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The","type":"text"},{"text":" {access-key} ","type":"text","marks":[{"type":"strong"}]},{"text":"is provided by Boxalino.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"As an integrator, please create the bellow request to the provided endpoint.","type":"text"}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"localId":"5abca078-b846-4c06-abb1-dea202e9f5c4"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Endpoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"text":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app","type":"text","marks":[{"type":"link","attrs":{"href":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"text":"/read/{access-key}","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Method","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"text":"POST","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Headers","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"Authorization","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[463.0]},"content":[{"type":"paragraph","content":[{"text":"Basic ","type":"text"},{"text":"base64","type":"text","marks":[{"type":"em"}]},{"text":"<>","type":"text"}]},{"type":"paragraph","content":[{"text":"note: use the API credentials from ","type":"text"},{"text":"your Boxalino account","type":"text","marks":[{"type":"link","attrs":{"href":"https://intelligence.bx-cloud.com/#/app/account"}}]},{"text":" that have the ","type":"text"},{"text":"PUBLIC_READ","type":"text","marks":[{"type":"strong"}]},{"text":" assigned ","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":1302,"id":"d123a77f-2b8e-4229-be5c-71134f46b9fe","collection":"contentId-842629121","type":"file","height":220}}]},{"type":"paragraph","content":[{"text":"*Read more about credentials ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/713785345"}},{"text":" ","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"The data exposed in the data feed is in a ","type":"text"},{"text":"JSON","type":"text","marks":[{"type":"strong"}]},{"text":" format.","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"The READ service is for authenticated access only. ","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"The data accessed is from a custom/private SQL script (as defined in the ","type":"text"},{"text":"{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" configuration), available for the account in the GCS bucket","type":"text"}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":1},"content":[{"text":"VIEW FEED REQUEST","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"There should be a process within client`s own project that accesses the data from the ","type":"text"},{"text":"/view/{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" service. Final format is ","type":"text"},{"text":"CSV file, to be downloaded","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The","type":"text"},{"text":" {access-key} ","type":"text","marks":[{"type":"strong"}]},{"text":"is provided by Boxalino.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"As an integrator, please create the bellow request to the provided endpoint.","type":"text"}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"localId":"e4365e98-9bca-41b6-b2eb-ff69dde6940c"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Endpoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"text":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app","type":"text","marks":[{"type":"link","attrs":{"href":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"text":"/view/{access-key}","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Method","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"text":"POST | GET","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":5,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Parameters (optional)","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"separator","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[463.0]},"content":[{"type":"paragraph","content":[{"text":"Default: comma (,)","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"Define a different separator for the .csv file ( tab, pipe (|), etc). ","type":"text"},{"text":"One character only!","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"NOTE: the default will be upgraded to “tab” in order to allow a list of data for value (ex: multivalue fields)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"format","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[463.0]},"content":[{"type":"paragraph","content":[{"text":"Default: csv","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"Change the format of export (ex: txt)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"page","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[463.0]},"content":[{"type":"paragraph","content":[{"text":"(optional) pagination; by default - all results are returned;","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"limit","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[463.0]},"content":[{"type":"paragraph","content":[{"text":"(optional) set a limit for number of rows per request","type":"text"}]},{"type":"paragraph","content":[{"text":"by default - no limit; when used with page - default limit is 1000.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"Authorization","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[463.0]},"content":[{"type":"paragraph","content":[{"text":"only if the key is for ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"em"}]},{"text":"authenticated","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"strong"},{"type":"em"}]},{"text":" requests","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"em"}]},{"type":"hardBreak"},{"text":"Basic ","type":"text"},{"text":"base64","type":"text","marks":[{"type":"em"}]},{"text":"<>","type":"text"}]},{"type":"paragraph","content":[{"text":"note: use the API credentials from ","type":"text"},{"text":"your Boxalino account","type":"text","marks":[{"type":"link","attrs":{"href":"https://intelligence.bx-cloud.com/#/app/account"}}]},{"text":" that have the ","type":"text"},{"text":"PUBLIC_READ","type":"text","marks":[{"type":"strong"}]},{"text":" assigned ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1302,"id":"d123a77f-2b8e-4229-be5c-71134f46b9fe","collection":"contentId-842629121","type":"file","height":220}}]},{"type":"paragraph","content":[{"text":"*Read more about credentials ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/713785345"}},{"text":" ","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"*Currently, the data exposed in the data feed is in a ","type":"text"},{"text":"CSV","type":"text","marks":[{"type":"strong"}]},{"text":" format.","type":"text"}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"The data accessed is from a custom view in ","type":"text"},{"text":"_views","type":"text","marks":[{"type":"code"}]},{"text":" dataset (as defined in the ","type":"text"},{"text":"{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" configuration). ","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"In order to use CSV headers with spaces, the ","type":"text"},{"text":"_S_","type":"text","marks":[{"type":"code"}]},{"text":" can be used within SQL select field names.","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Parametrized queries are supported (","type":"text"},{"type":"inlineCard","attrs":{"url":"https://cloud.google.com/bigquery/docs/parameterized-queries"}},{"text":" ). Simply use ","type":"text"},{"text":"'@'","type":"text","marks":[{"type":"code"}]},{"text":" in the view`s SQL and define the same parameter as ","type":"text"},{"text":"_=","type":"text","marks":[{"type":"code"}]},{"text":" to the feed URL.","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"NOTE: all parameter values are casted as STRING.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"VIEW GOOGLEADSFEED REQUEST","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"There should be a process within clients' own project that accesses the data from the ","type":"text"},{"text":"/view/googleadsfeed/{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" service. Final format is ","type":"text"},{"text":"CSV file, to be downloaded","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The","type":"text"},{"text":" {access-key} ","type":"text","marks":[{"type":"strong"}]},{"text":"is provided by Boxalino.","type":"text"}]},{"type":"paragraph","content":[{"text":"It is only valid for this service.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"As an integrator, please create the bellow request to the provided endpoint.","type":"text"}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"localId":"c4d92cfd-5746-4cad-b80d-b19212ce10cd"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Endpoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"text":"/view/googleadsfeed/{access-key}?name=","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Method","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":2,"rowspan":1,"colwidth":[145.0,463.0]},"content":[{"type":"paragraph","content":[{"text":"POST | GET","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":2,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Parameters (optional)","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"separator","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[463.0]},"content":[{"type":"paragraph","content":[{"text":"Default: comma (,)","type":"text"}]},{"type":"paragraph","content":[{"text":"Define a different separator for the .csv file ( tab, pipe (|), etc). ","type":"text"},{"text":"One character only!","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"NOTE: the default will be upgraded to “tab” in order to allow a list of data for value (ex: multivalue fields)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"format","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[463.0]},"content":[{"type":"paragraph","content":[{"text":"Default: csv","type":"text"}]},{"type":"paragraph","content":[{"text":"Change the format of export (ex: txt)","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"*Currently, the data exposed in the data feed is in a ","type":"text"},{"text":"CSV","type":"text","marks":[{"type":"strong"}]},{"text":" format.","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"The difference between a simple CSV export and a CSV format compatible with Google Ads Uploads is around the ","type":"text"},{"text":"Parameters","type":"text","marks":[{"type":"code"}]},{"text":" properties before the table header.","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"The parameters must be defined in the clients` views dataset , in the ","type":"text"},{"text":"google_ads_data_feeds_parameters","type":"text","marks":[{"type":"code"}]},{"text":" table. ","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"The service will replace every ","type":"text"},{"text":"_","type":"text","marks":[{"type":"code"}]},{"text":" from the SQL field names with a space.","type":"text"}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"JSON FEED REQUEST","type":"text"}]},{"type":"paragraph","content":[{"text":"As an integrator, please create the bellow request to the provided endpoint.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"There should be a process within your own project that requires the data from the ","type":"text"},{"text":"/json/{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" service. Final format is ","type":"text"},{"text":"JSON","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The","type":"text"},{"text":" {access-key} ","type":"text","marks":[{"type":"strong"}]},{"text":"is provided by Boxalino.","type":"text"}]}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"localId":"6cf8bee2-0c45-49f4-9222-d4671bde1502"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Endpoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"/json/{access-key}?name=","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Method","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"POST | GET","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Authorization ","type":"text"},{"text":"(header)","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"only if the key is for ","type":"text","marks":[{"type":"em"}]},{"text":"authenticated","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" requests","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Basic ","type":"text"},{"text":"base64","type":"text","marks":[{"type":"em"}]},{"text":"<>","type":"text"}]},{"type":"paragraph","content":[{"text":"note: use the API credentials from ","type":"text"},{"text":"your Boxalino account","type":"text","marks":[{"type":"link","attrs":{"href":"https://intelligence.bx-cloud.com/#/app/account"}}]},{"text":" that have the ","type":"text"},{"text":"PUBLIC_READ","type":"text","marks":[{"type":"strong"}]},{"text":" assigned ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1302,"id":"d123a77f-2b8e-4229-be5c-71134f46b9fe","collection":"contentId-842629121","type":"file","height":220}}]},{"type":"paragraph","content":[{"text":"*Read more about credentials ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/713785345"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":2,"rowspan":1,"colwidth":[109.0,145.0]},"content":[{"type":"paragraph","content":[{"text":"Parameters (optional)","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"page","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"(optional) pagination; by default - all results are returned;","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"limit","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"(optional) set a limit for number of rows per request","type":"text"}]},{"type":"paragraph","content":[{"text":"by default - no limit; when used with page - default limit is 1000.","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"The data exposed in the data feed is in a ","type":"text"},{"text":"JSON","type":"text","marks":[{"type":"strong"}]},{"text":" format.","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"The JSON feed rely on the presence of a source in the ","type":"text"},{"text":"_views","type":"text","marks":[{"type":"code"}]},{"text":" dataset in BigQuery. ","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Parametrized queries are supported (","type":"text"},{"type":"inlineCard","attrs":{"url":"https://cloud.google.com/bigquery/docs/parameterized-queries"}},{"text":" ). Simply use ","type":"text"},{"text":"'@'","type":"text","marks":[{"type":"code"}]},{"text":" in the view`s SQL and define the same parameter as ","type":"text"},{"text":"_=","type":"text","marks":[{"type":"code"}]},{"text":" to the feed URL.","type":"text"}]},{"type":"paragraph","content":[{"text":"NOTE: all parameter values are casted as STRING.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":1},"content":[{"text":"GOOGLE SHOPPING FEED REQUEST","type":"text"}]},{"type":"paragraph","content":[{"text":"As an integrator, please create the bellow request to the provided endpoint.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"There should be a process within your own project that accesses the data from the ","type":"text"},{"text":"/googleshoppingfeed/{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" service.","type":"text"}]},{"type":"paragraph","content":[{"text":"Final format is ","type":"text"},{"text":"tab delimited .txt","type":"text","marks":[{"type":"strong"}]},{"text":" (per ","type":"text"},{"text":"Google Shopping Feed requirements","type":"text","marks":[{"type":"link","attrs":{"href":"https://support.google.com/merchants/answer/160588?hl=en#zippy=%2Cformat-requirements"}}]},{"text":"). The data is formated based on Google Shopping Feed rules: ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://support.google.com/merchants/answer/7052112"}},{"text":" ","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"The","type":"text"},{"text":" {acces-key} ","type":"text","marks":[{"type":"strong"}]},{"text":"is provided by Boxalino.","type":"text"}]},{"type":"paragraph","content":[{"text":"It is only valid for this service.","type":"text"}]}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"localId":"99862250-88ed-4e75-8760-0ce69cb1d195"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Endpoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"/googleshoppingfeed/{access-key}","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Method","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"POST | GET","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Authorization ","type":"text"},{"text":"(header)","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"only if the key is for ","type":"text","marks":[{"type":"em"}]},{"text":"authenticated","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" requests","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Basic ","type":"text"},{"text":"base64","type":"text","marks":[{"type":"em"}]},{"text":"<>","type":"text"}]},{"type":"paragraph","content":[{"text":"note: use the API credentials from ","type":"text"},{"text":"your Boxalino account","type":"text","marks":[{"type":"link","attrs":{"href":"https://intelligence.bx-cloud.com/#/app/account"}}]},{"text":" that have the ","type":"text"},{"text":"PUBLIC_READ","type":"text","marks":[{"type":"strong"}]},{"text":" assigned ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1302,"id":"d123a77f-2b8e-4229-be5c-71134f46b9fe","collection":"contentId-842629121","type":"file","height":220}}]},{"type":"paragraph","content":[{"text":"*Read more about credentials ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://boxalino.atlassian.net/wiki/spaces/BPKB/pages/713785345"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":2,"rowspan":1,"colwidth":[109.0,145.0]},"content":[{"type":"paragraph","content":[{"text":"Parameters (optional)","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"page","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"(optional) pagination; by default - all results are returned;","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"limit","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"(optional) set a limit for number of rows per request","type":"text"}]},{"type":"paragraph","content":[{"text":"by default - no limit; when used with page - default limit is 1000.","type":"text"}]}]}]}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"The data accessed is from a custom view in ","type":"text"},{"text":"_views","type":"text","marks":[{"type":"code"}]},{"text":" dataset (as defined in the ","type":"text"},{"text":"{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" configuration)","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"In order to use CSV headers with spaces, the ","type":"text"},{"text":"_S_","type":"text","marks":[{"type":"code"}]},{"text":" can be used within SQL select field names.","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Parametrized queries are supported (","type":"text"},{"type":"inlineCard","attrs":{"url":"https://cloud.google.com/bigquery/docs/parameterized-queries"}},{"text":" ). Simply use ","type":"text"},{"text":"'@'","type":"text","marks":[{"type":"code"}]},{"text":" in the view`s SQL and define the same parameter as ","type":"text"},{"text":"_=","type":"text","marks":[{"type":"code"}]},{"text":" to the feed URL.","type":"text"}]},{"type":"paragraph","content":[{"text":"NOTE: all parameter values are casted as STRING.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"LOAD FEED REQUEST","type":"text"}]},{"type":"paragraph","content":[{"text":"The LOADFEED service was created in order to load files directly into your project`s BigQuery ecosystem from Boxalino.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"There should be configurations in the ","type":"text"},{"text":"input_data_feeds","type":"text","marks":[{"type":"code"}]},{"text":" view from ","type":"text"},{"text":"_views","type":"text","marks":[{"type":"code"}]},{"text":" dataset.","type":"text"},{"type":"hardBreak"},{"text":"Use the ","type":"text"},{"text":"/loadfeed/{access-key}?name=","type":"text","marks":[{"type":"code"}]},{"text":" action in order to validate your configurations.","type":"text"}]},{"type":"paragraph","content":[{"text":"The","type":"text"},{"text":" {access-key} ","type":"text","marks":[{"type":"strong"}]},{"text":"is provided by Boxalino.","type":"text"}]},{"type":"paragraph","content":[{"text":"It is only valid for this service.","type":"text"}]}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"localId":"b882f42b-f3fc-4894-8ab9-7953ade9ced0"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Endpoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"/loadfeed/{access-key}?name=","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Method","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"POST | GET","type":"text"}]}]}]}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"Once the view model is configured, the files will get loaded per desired frequency (as configured via the ","type":"text"},{"text":"cronjob","type":"text","marks":[{"type":"code"}]},{"text":" property). ","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Adding a new loadfeed configuration model","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"As an integrator, check that you have ","type":"text"},{"text":"write","type":"text","marks":[{"type":"strong"}]},{"text":" permissions to the ","type":"text"},{"text":"_views","type":"text","marks":[{"type":"code"}]},{"text":" dataset in order to continue:","type":"text"}]},{"type":"paragraph","content":[{"text":"Go to ","type":"text"},{"text":"Google Cloud BigQuery","type":"text","marks":[{"type":"link","attrs":{"href":"https://console.cloud.google.com/bigquery"}}]},{"text":" and run the SQL: ","type":"text"},{"type":"hardBreak"},{"text":"SELECT * FROM `bx-bdp-53322._views.input_data_feeds` ","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"In case you do not have permissions, contact Boxalino on slack or via email datafeed@boxalino.com","type":"text"}]}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"loadfeed","type":"text","marks":[{"type":"code"}]},{"text":" configuration model is defined in the ","type":"text"},{"text":"input_data_feeds","type":"text","marks":[{"type":"code"}]},{"text":" view in the client`s account dataset.","type":"text"}]},{"type":"codeBlock","content":[{"text":"SELECT\n'' as name\n, '' AS source\n, '' AS access\n, '' AS url\n, '' AS body\n, ';' AS field_delimiter\n, '' AS format\n, '_core' AS destination_dataset\n, '' AS destination_table\n, true AS autodetect\n, '' AS schema\n, 0 AS add_body_as_record\n, 0 AS add_tm_to_record\n, 1 AS skipRows\n, 0 AS max_bad_records\n, '' AS quote\n, 'WRITE_TRUNCATE | WRITE_APPEND' AS write_disposition\n, '' AS create_disposition\n, '' AS encoding\n, '' AS cronjob\n, 'feed' AS type","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"The integration sources are expanding per client request. Currently, it is able to load content ","type":"text"},{"text":"direct","type":"text","marks":[{"type":"code"}]},{"text":" (via URL) and from ","type":"text"},{"text":"aws","type":"text","marks":[{"type":"code"}]},{"text":" storage buckets. ","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"In the case of ","type":"text"},{"text":"direct","type":"text","marks":[{"type":"code"}]},{"text":" access, it is possible to set headers (in the ","type":"text"},{"text":"access","type":"text","marks":[{"type":"code"}]},{"text":" property) and also define a JSON ","type":"text"},{"text":"body","type":"text","marks":[{"type":"code"}]},{"text":" to be sent as load. It can be used in the case of making API requests (to Boxalino or 3rd party services like ChatGPT, Deepl, OpenAI, etc).","type":"text"}]}]},{"type":"panel","attrs":{"panelIconId":"atlassian-check_mark","panelIcon":":check_mark:","panelIconText":":check_mark:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"It is possible to configure dynamic ","type":"text"},{"text":"url","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"destination_table","type":"text","marks":[{"type":"code"}]},{"text":" (ex: if the file to be loaded is stored in a different path or has a timestamp for name). The supported variations are:","type":"text"},{"type":"hardBreak"},{"text":"__DATE__","type":"text","marks":[{"type":"code"}]},{"text":" (Y-m-d), ","type":"text"},{"text":"__NODASHDATE__","type":"text","marks":[{"type":"code"}]},{"text":" (Ymd), ","type":"text"},{"text":"__TM__","type":"text","marks":[{"type":"code"}]},{"text":" (Y-m-dTH:i:s), ","type":"text"},{"text":"__NODASHTM__","type":"text","marks":[{"type":"code"}]},{"text":" (YmdHis), ","type":"text"},{"text":"__DATE_PATH__","type":"text","marks":[{"type":"code"}]},{"text":" (Y/m/d), ","type":"text"},{"text":"__JN_DATE_PATH__","type":"text","marks":[{"type":"code"}]},{"text":" (Y/n/j), ","type":"text"},{"text":"__DATE_YESTERDAY__","type":"text","marks":[{"type":"code"}]},{"text":" (Y-m-d -1 day), ","type":"text"},{"text":"__DATE_MONTH__","type":"text","marks":[{"type":"code"}]},{"text":" (Y-m-01), ","type":"text"},{"text":"__NODASHDATE_MONTH__","type":"text","marks":[{"type":"code"}]},{"text":" (Ym01), ","type":"text"},{"text":"__NODASHDATE_YESTERDAY__","type":"text","marks":[{"type":"code"}]},{"text":" (Ymd -1 day)","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Loading of content in BigQuery is following the configurations modes & limitations per Google Cloud documentation.","type":"text"},{"type":"hardBreak"},{"text":"For CSV: ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv"}},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":"For JSONL: ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-json"}},{"text":" ","type":"text"}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"GOOGLE SHEET FEED REQUEST","type":"text"}]},{"type":"paragraph","content":[{"text":"The GOOGLESHEETFEED service was created in order to import google sheets directly into your project`s BigQuery ecosystem from Boxalino.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"The Google Sheet used for load must share ","type":"text"},{"text":"VIEW PERMISSIONS","type":"text","marks":[{"type":"strong"}]},{"text":" with our service account ","type":"text"},{"text":"boxalino-google-sheet-feed@rtux-data-integration.iam.gserviceaccount.com","type":"text","marks":[{"type":"underline"},{"type":"link","attrs":{"href":"mailto:boxalino-google-sheet-feed@rtux-data-integration.iam.gserviceaccount.com"}}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"There should be configurations in the ","type":"text"},{"text":"google_sheet_data_feeds","type":"text","marks":[{"type":"code"}]},{"text":" view from ","type":"text"},{"text":"_views","type":"text","marks":[{"type":"code"}]},{"text":" dataset.","type":"text"},{"type":"hardBreak"},{"text":"Use the ","type":"text"},{"text":"/googlesheetfeed/{access-key}","type":"text","marks":[{"type":"code"}]},{"text":" action in order to validate your configurations.","type":"text"}]},{"type":"paragraph","content":[{"text":"The","type":"text"},{"text":" {access-key} ","type":"text","marks":[{"type":"strong"}]},{"text":"is provided by Boxalino.","type":"text"},{"type":"hardBreak"},{"text":"It is only valid for this service.","type":"text"}]}]},{"type":"table","attrs":{"layout":"default","isNumberColumnEnabled":true,"localId":"6c5e1a0c-8b1e-4e06-8dfd-0e1a352c6841"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Endpoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://boxalino-winning-interactions-krceabfwya-ew.a.run.app"}},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"/googlesheetfeed/{access-key}?name=","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Method","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[145.0]},"content":[{"type":"paragraph","content":[{"text":"POST | GET","type":"text"}]}]}]}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"Once the views is configured, the files will get loaded per desired frequency (as configured). ","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Adding a new googlesheetfeed configuration model","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"As an integrator, check that you have ","type":"text"},{"text":"write","type":"text","marks":[{"type":"strong"}]},{"text":" permissions to the ","type":"text"},{"text":"_views","type":"text","marks":[{"type":"code"}]},{"text":" dataset in order to continue:","type":"text"}]},{"type":"paragraph","content":[{"text":"Go to ","type":"text"},{"text":"Google Cloud BigQuery","type":"text","marks":[{"type":"link","attrs":{"href":"https://console.cloud.google.com/bigquery"}}]},{"text":" and run the SQL: ","type":"text"},{"type":"hardBreak"},{"text":"SELECT * FROM `bx-bdp-53322._views.google_sheet_data_feeds` ","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"In case you do not have permissions, contact Boxalino on slack or via email ","type":"text"},{"text":"datafeed@boxalino.com","type":"text","marks":[{"type":"link","attrs":{"href":"mailto:datafeed@boxalino.com"}}]}]}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"googlesheetfeed","type":"text","marks":[{"type":"code"}]},{"text":" configuration model is defined in the ","type":"text"},{"text":"google_sheet_data_feeds","type":"text","marks":[{"type":"code"}]},{"text":" view in the client`s account dataset.","type":"text"}]},{"type":"codeBlock","content":[{"text":"SELECT\n'' as name\n, '' AS id\n, '' AS sheet_range\n, ';' AS field_delimiter\n, 'CSV' AS format\n, '_core' AS destination_dataset\n, '

' AS destination_table\n, true AS autodetect\n, '' AS schema\n, 1 AS skipRows\n, 0 AS max_bad_records\n, '' AS quote\n, 'WRITE_TRUNCATE | WRITE_APPEND' AS write_disposition\n, '' AS create_disposition\n, '' AS encoding\n, '' AS cronjob\n, 'googlesheet' AS type","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1248,"id":"dd3c8436-4683-46ca-af2a-035e46c1c20a","collection":"contentId-842629121","type":"file","height":280}}]}],"version":1}