How can the matelso API call data be transferred to a Google Sheet?

API

Do you want to import your call data directly from matelso into your Google Sheets for further editing?

This is very easy to do – simply create a Google Sheet and enter the following line in cell A1 to retrieve the matelso API data:

Code:

=IMPORTXML("https://api.matelso.com/V2/calltracking.asmx/show_calls?partner_id=XXXXX&partner_password=XXXXXX&start_date=01.01.2019&end_date=01.09.2019"; "//item/data")

Requirement: The matelso API must be activated for your account.

The matelso API activates or uses the method show_calls. See also the API documentation in the Control Panel.

To be added individually in the line:

  1. Partner ID=xxx (note: user accounts do not work here, this must be the API account/partner ID)
  2. API/partner password=xxx (caution: password must be URL-encoded! See for example: https://www.urlencoder.io/)
  3. Start/Enddatum=Gewünschter Call-Reportzeitraum (Format: DD.MM.YYYY)

In principle, all matelso API methods can be accessed this way.