Rest Queries
XLCubed allows you to connect directly to REST datasources to build tables.
Designer
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