Difference between revisions of "Rest Queries"

(Designer)
Line 2: Line 2:
  
 
==Designer==
 
==Designer==
[[Image:RestDesigner.png|500px| thumb]]
+
[[Image:RestDesigner.png|500px| center|thumb]]
  
 
===Query Properties===
 
===Query Properties===

Revision as of 14:58, 8 December 2017

XLCubed allows you to connect directly to REST datasources to build tables.

Designer

RestDesigner.png

Query Properties

  • Query: You can enter the data source url directly, or drive it from an Excel Range
  • Parameters: An Excel range with two columns, for parameter names and values. These will be appended to the querystring.
  • Send Content-Type: Sets the "Accept" content type header when the request is run.
  • Mode: Format of the returned data.

Response Properties

You can the configure how the response will be handled. This varies by data format, and allows you to handle data from various locales.

For Xml and Json formats you can specify

  • The path to the items to select if they are not at the root of the document
  • The elements to select as columns for each item