WHAT IS THE REPORTING API

The reporting API  is used for fetching data from Qondor into other systems, like:

  • Internal datawarehouse for Business Intelligence purposes

  • Cloud Big Data environments like Google BigQuery or Hadoop

  • Direct fetch from reporting solutions like Tableau or Bime Analytics

  • Transfer information from Qondor to other systems like SalesForce etc


MAKING REQUESTS

The Access Token needs to be included in every request. The overall access to the data is based on the Access Token, but you can further limit the response by using the following request parameters.

Request parameters

  • officeId (optional) - limit the results by office

  • teamId (optional) - limit the results by team

  • projectLeaderId (optional) - limit results by Project Manager

  • fromDate (optional) - Range filter

  • toDate (optional) - Range filter

  • dateType (optional)  Specifies the meaning of the parameters 'fromDate' and 'toDate'. 1 = CreatedDate (Default if not specified) 2 = ConfirmedDate 3 = DepartureDate 4 = ArrivalDate

  • projectId (optional) - Limit results to one project

Response content

The response is a JSON Array with projects. For each project you can retrieve the following information:

Office Information
Information about the office, name and currency code, project manager and team information

Project details

Project No, Name, Lead from, Category, Customer information, departure and return dates, status (Pending, Confirmed, Finished, Cancelled with cancel reason), destination, number of people

Financial details
Budget sales & revenue, real sales & revenue, probability percentage, confirmed sales/revenue on air/rail, hotels and other products/services, sales/revenue from attendees, invoiced sales/revenue to customer & attendees, confirmed roomnights split by single/double room.


Detailed information on field names is available through the API portal, which can be accessed after receiving the Access Token.

Did this answer your question?