plain text
=IMPORTDATA("https://api.octolis.cloud/v1/data/audiences/{{audienceId}}/records?api-key={{apiKey}}&pageSize=10000&page=1&format=csv&selection={{columnList}}")

• audienceId : (mandatory) The ID of the Audience you want to extract data from (ask Support if you don’t find it). Please replace {{audienceId}} in the above.

• apiKey : (mandatory) Your API key that will be provided by our Support. Please replace {{apiKey}} in the above

• format : (mandatory) Export format must be set as csv for Google Sheet.

• pageSize : (optional) Results page size, must be a positive integer ("50000" by default, which also is the maximum size of a page).

• page : (optional) Results page number (optional): positive integer ("1" by default).

• selection : (optional) Selection of columns that should be retrieved. Please replace {{columnList}} in the above. Example: selection=email,firstname,masterid

• filter : (optional) Equality filters applied on the records (optional). Using several filters on the same column will result in an OR condition. Exemple : filter=firstname:Marc,firstName:Jeanne,consent_sms:true

• header : (optional) Export headers for CSV format (optional): "true" (default) or "false".

• order : (optional) Sorting for the results "asc" or "desc" (default), done on our system modified_at column.

plain text
={IMPORTDATA("https://api.octolis.cloud/v1/data/audiences/{{audienceId}}/records?api-key={{apiKey}}&pageSize=50000&page=1&format=csv&selection={{columnList}}");IMPORTDATA("https://api.octolis.cloud/v1/data/audiences/{{audienceId}}/records?api-key={{apiKey}}&pageSize=50000&page=2&header=false&format=csv&selection={{columnList}}");IMPORTDATA("https://api.octolis.cloud/v1/data/audiences/{{audienceId}}/records?api-key={{apiKey}}&pageSize=50000&page=3&header=false&format=csv&selection={{columnList}}")}