Import data into Bime

To get started, simply download the BIME application or the online trial version.
Once the application is open, you can begin importing data.

Select a data source

BIME offers numerous possibilities for data connection. You may choose from the available library: flat files, connectors, or SQL databases.

To connect your AT Internet data, choose the REST connector and click ‘Next’.

Create a Rest set up

This important step allows you to establish the setup of your REST connector and to import your AT Internet data into BIME.

The simplest way to do this is by using the REST connection feature available in the above library.

You’ll then be able to load a REST URL (in XML or JSON format) which you can obtain directly in the Data Query application within AT Internet’s Analytics Suite.

Create a Data Query request (or use an existing template)

Build your query in Data Query and select the API REST URL relating to your data set.

To be able to import data into BIME, it is mandatory to have the Data Explorer option activated on your account, which will allow you to access the Data Query application.

Go into Data Query:

Create a template or use an existing template:

Import data from the AT Internet API to Bime

Select the URL created below the dataset in the desired format.

The import will not work with long URL mode. Please remember to select the short URL mode, as shown in the below screenshot.

  • Paste this Data Query URL into the BIME interface’s GET/JSON URL section.
  • Add the following optional parameter to format data returned in BIME: $.DataFeed[0].Rows
  • During the import, you will be asked to enter your AT Internet account login and password. Select the basic authentication mode, as in the below example.

Now, you must specify the different parameters making up this API URL by clicking on "parameters" next to the "authentication" section.
The URL put forth by the Data Query application offers the following parameters:

https://apirest.atinternet-solutions.com/data/v2/json/getData?&columns={d_source,m_visits}&sort={-m_visits}&space={s:554331}&period={D:'2016-03-21'}&max-results=50&page-num=1

Simply place these parameters into the various fields below:

To test and save your data connection, remember to verify that you’re always authenticated at each step, and that your query has a name.

 

Create your own queries

By default, Bime offers you certain queries, but it's entirely possible to create your own. Bime will sort the fields of your data source into attributes and measures according to the content in each field.

To learn more about Query Builder, please consult the Bime support centre.

Once your data is formatted, Bime will import it and suggest that you access Query Builder. This tool allows you to pair measures or attributes in order to build the visualisation that's most adapted to your needs. Create colour coding, build filters, or customise your query by adding a table or by editing the axes options.

Bime will select the type of visualisation that's most adapted to your query.

Have more questions? Submit a request