Difference between revisions of "Rest Queries"
(Created page with "XLCubed allows you to connect directly to [https://en.wikipedia.org/wiki/Representational_state_transfer REST] datasources to build tables. Image:RestDesigner.png|500px| th...") |
|||
| Line 1: | Line 1: | ||
XLCubed allows you to connect directly to [https://en.wikipedia.org/wiki/Representational_state_transfer REST] datasources to build tables. | XLCubed allows you to connect directly to [https://en.wikipedia.org/wiki/Representational_state_transfer REST] datasources to build tables. | ||
| − | [[Image:RestDesigner.png|500px| thumb | + | ==Designer== |
| + | [[Image:RestDesigner.png|500px| thumb]] | ||
| + | ===Query Properties=== | ||
* Query: You can enter the data source url directly, or drive it from an Excel Range | * 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. | * Parameters: An Excel range with two columns, for parameter names and values. These will be appended to the querystring. | ||
| Line 8: | Line 10: | ||
* Mode: Format of the returned data. | * 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. | You can the configure how the response will be handled. This varies by data format, and allows you to handle data from various locales. | ||
Revision as of 14:58, 8 December 2017
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
