Export possibilities - Export pop-up

If you wish to retrieve your data (in an Excel file, for example), you can export your results and your templates by clicking the "Export" button.

Two formats are available: CSV and IQY.

You can then give your file a name, and choose the decimal separator you prefer (period or comma).

 

 

CSV

The CSV format is a standard format for exchanging data.

By default, the file name is the same as the template name. If you have not saved your template, the default name is mycsv. Before exporting a file, you'll need to indicate which decimal separator you prefer, as well as the number of elements to be returned.

 

 

IQY

The IQY format is a format specific to Microsoft. It enables you to create interconnections between our API and Excel. Use it to build dynamic dashboards, for which you can update data directly from Excel, with no technical manœuvres needed.

Before exporting a file, you'll need to indicate which decimal separator you prefer, as well as the number of elements to be returned. You must also specify the parameters you wish to make dynamic. By making parameters dynamic, you'll be able to edit the value directly in your Excel file. 

Tip: You may also make other parameters of your IQY dynamic, by opening your IQY using your code editor. You will need to replace the value of the parameter with '["Text","Text to display in the Excel pop-in"]'.

 

For example with this IQY, the period to select must be made dynamic:
https://apirest.atinternet-solutions.com/v2/html/getData?&columns={d_time_date,m_visits}&sort={-m_visits}&space={s:XXXXXX}&period={D:{start:'["Start","Please enter a start date in the format YYYY-MM-DD"]',end:'["End","Please enter an end date in the format YYYY-MM-DD"]'}}&page-num=1&sep=comma&max-results=20

 

 

Configuration

To export your data according to the desired format, you will need to:

  • Fill in the template's default period (this can be made dynamic using the IQY)
  • Fill in at least one dimension and one metric

By default, there are 20 answers per page. You can set this to up to 1,000 rows in the interface, and 100,000 rows for a CSV. The page element lets you indicate the elements you wish to obtain. For example, for a call that sends back 60 rows, as there are only 20 rows per page, you'll find rows 21 to 40 when you select page 2.

 

 

 

Have more questions? Submit a request