Document toolboxDocument toolbox

Using and managing OData feeds

API versions

Please note that newer versions of this API may include pure additions to it (such as new properties on resources returned from an action, accepting these resources with or without the property inbound to the server, or adding new resources or actions), or new appearance of properties within JSON structures, because we assume that clients use forgiving, non-strict parsing on the JSON they receive from Devo.

New versions of the API will always be backward compatible, using a never remove, only add strategy. Contact us in case you have any question.

This article explains how to set up a Devo data query as an OData feed. This will allow you to stream the data to external tools like, for example, Microsoft ExcelTableau or Power BI. Currently, Devo feeds implement OData version 2.0.

The service root URL for OData feeds depends on your Devo domain region:

EU

https://api-eu.devo.com/odatav2/Query.svc

US

https://api-us.devo.com/odatav2/Query.svc

CA

https://api-ca.devo.com/odatav2/Query.svc

APAC

https://api-apac.devo.com/odatav2/Query.svc

Set up an OData feed

Manage feeds

All the feeds that have been created in your domain are listed in the API & OData Feeds tab of the Administration → Credentials → Tokens area. Check the Authentication tokens article for more information.

OData feed parameters

You can add query string parameters to the OData feed URI to specify the data you want to retrieve. These parameters can be used to, for example, control the amount and order of the data that an OData service returns for the query identified by the URI.

OData feed URIs may include as many parameters as required, which are always prefixed with a "&" character (except the $metadata parameter). 

The following table lists the supported parameters using a feed URL for a Devo domain in the USA cloud region:



$top

Add the $top parameter to return only the first N events of the query.

Example

https://api-us.devo/odatav2/Query.svc/716ae082-4943-43b-ab3a-48940fb168ce/544dd94cfaa4e48e831f0e7e26d8fa3/query?from=2018-10-03T07:00:00&to=2018-10-04T07:10:00&$top=10



$skip

Add the $skip parameter to skip the first N events and show only the remaining ones.

Example

https://api-us.devo/odatav2/Query.svc/716ae082-4943-43b-ab3a-48940fb168ce/544dd94cfaa4e48e831f0e7e26d8fa3/query?from=2018-10-03T07:00:00&to=2018-10-04T07:10:00&$skip=9



$select

Add the $select parameter to specify the columns of the data table you want to retrieve.

Example

https://api-us.devo/odatav2/Query.svc/716ae082-4943-43b-ab3a-48940fb168ce/544dd94cfaa4e48e831f0e7e26d8fa3/query?from=2018-10-03T07:00:00&to=2018-10-04T07:10:00&$select=eventdate,cid







$format

Add the $format parameter to return the data in a specific format. The valid formats are:

  • Atom xml (default format)

  • JSON

Add =json or =xml after the parameter to indicate the format. For example: &$format=json

Example

https://api-us.devo/odatav2/Query.svc/716ae082-4943-43b-ab3a-48940fb168ce/544dd94cfaa4e48e831f0e7e26d8fa3/query?from=2018-10-03T07:00:00&to=2018-10-04T07:10:00&$format=json





timezone

Add the timezone parameter to indicate that the dates of the from and to parameters, as outlined further below, are relative to the timezone indicated. The possible values for this parameter come from an IANA standard and more information can be found here.

Example

https://api-us.devo/odatav2/Query.svc/716ae082-4943-43b-ab3a-48940fb168ce/544dd94cfaa4e48e831f0e7e26d8fa3/query?from=2018-10-03T07:00:00&to=2018-10-04T07:10:00&timezone=Europe/Madrid

Note that if no timezone is specified then UTC is always used by default. In the example provided, Madrid is UTC+2 during summertime and UTC+1 during daylight savings time. 





$metadata

Add the $metadata parameter to return only the query metadata. You cannot combine this parameter with other parameters.

To add this parameter to the OData feed URI, first remove the query time information at the end of the URL, then add the parameter without including the '&' character.

Example

https://api-us.devo/odatav2/Query.svc/716ae082-4943-43b-ab3a-48940fb168ce/544dd94cfaa4e48e831f0e7e26d8fa3/query?from=2018-10-03T07:00:00&to=2018-10-04T07:10:00$metadata

The following is an example of an OData feed with four different parameters:

https://api-us.devo/odatav2/Query.svc/0c6f1165-4ac8-4ca4-87df-06bede2d1f53/e59f069b5bf113da8101372f50d90b8b/query?from=2018-10-02T09:40:18.224&to=2018-10-03T09:40:00&$select=eventdate,cid&$top=10&$skip=9&$format=json

In this case, you will only receive the data in the eventdate and cid columns, as specified in the select parameter. The top parameter indicates that only the first 10 events will be shown and the skip parameter will make the counting start after the first nine events. As a result, only 10 events from the event number 10 will be shown. Data will be retrieved in JSON format as indicated in the format parameter.

See the OData documentation for further details.

Working with relative time ranges

A relative date range is a period of time that is relative to the current date (last week, last month, etc). There are some rules to consider when using the relative date ranges in OData URI:

  • If you run a query without from, the request will use [dateTo - 1h, dateTo] as time range.

  • If you run a query without to, the request will use [dateFrom, now] as time range.

  • If you run a query without from and to, the request will use [now - 1h, now] as time range.

  • If you run a query using to → from, the request will use [from, now] as time range.

  • If you run a query using now → from, the request will use [now - 1h, now] as time range

See below the parameters you can add to your OData URI to apply relative date ranges.

From (defines the start date)

  • Relative - It retrieves the current time (day, month, hour, minutes and seconds) excluding a specified range of days/hours. The valid range dates you can use are days(d) and hours(h).

Example

Suppose the current date is 22/08/2016 15:20:00.

  • &from=1d → 21/08/2016 15:20:00

  • &from=7d → 15/08/2016 15:20:00

  • &from=24h -> 21/08/2016 15:20:00

  • &from=11h -> 22/08/2016 04:20:00

  • &from=26h -> 21/08/2016 13:20:00

  • Absolute - The only valid range date you can use is days(d).

Example

Suppose the current date is 22/08/2016 15:20:00.

  • &from=1ad -> 21/08/2016 00:00:00

  • &from=7ad -> 15/08/2016 00:00:00

  • Specific - They are specific filters using the current date and hour, but the minutes and seconds are setup as 0.

To (defines the end date)

  • Relative - The valid range dates you can use are days(d) and hours.

  • Absolute - The only valid range dates you can use are days(d).

  • Specific - Based on specific operators such as end of day, end of month, etc.
    &to=now - it retrieves the current hour, minutes and seconds.

&to=endday - covers the range time between "from" date and the end of the day. It's the same as "&to=1ad".

&to=endmonth - covers the range time between the current date and the end of the month.

Related articles