Guide: Importing Demand Forecasts Using R+ Data API 2.0

Our new Data API Service (Currently in Preview as of July 2016) supports input and output of all our data files. Internally these are known as “System of Record” types.

Please see our full documentation of the RESTful methods we currently support in this API here: Data API 2.0

There are 3 important http header values:

• api_key – The R+ API Authentication Token. You will need to generate one of these.

• Content-Type – This is used when you PUT your data into the web service, and we support 3 types of content. XML, JSON, and CSV.

  • text/csv - NOTE: Only supported on "System of Record" item requests (i.e. /{id}/systemofrecordtype)

  • text/xml

  • application/xml

  • application/json

• Accept-Type – This is how your response will be formatted. i.e. Constraint errors, as well as the resultant data response. We support XML & JSON site wide, but will also return CSV on the 10 “System of Record” API endpoints if specified.

• • text/csv - NOTE: Only supported on "System of Record" item requests (i.e. /{id}/systemofrecordtype)

  • text/xml

  • application/xml

  • application/json

Here is an example request/response to import a demand forecast CSV into the system using our API.

Please note: You will need to use the same CSV formatting as you have defined in the “System Data Exchange” section of your R+ site. This includes things like regional decimal format, record delimiters, and date format.