{"info":{"_postman_id":"ca15d887-9f77-4868-aa8c-96edc7af671c","name":"Model Creation - Demo Collection","description":"

A collection of example requests.

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"6470514","collectionId":"ca15d887-9f77-4868-aa8c-96edc7af671c","publishedId":"TW6tMAFR","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2021-01-24T16:56:48.000Z"},"item":[{"name":"Query Requests","item":[{"name":"Run tabulation query.","id":"2b8d7357-ec90-4740-b05d-ec8ef86c07b4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","description":"

\nRunning tabulations on the specified data product returns aggregate level\ndata about the dimensions and measures specified. A variety of querying\ntechniques can be used to subset, compute, order, filter and format the\nresults.\n

\n\n

Related Models

The following models are used in this request. View the model documentation to learn more about what it is and how it fits into this and other requests

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Model	Location
MTNA Data Set	RESPONSE
Plotly Box Plot	RESPONSE
RDS Data Set	RESPONSE
Plotly Bubble Chart	RESPONSE
Plotly Bar Chart	RESPONSE
Plotly Pie Chart	RESPONSE
Plotly Histogram	RESPONSE
Google Chart Data Set	RESPONSE
AmCharts Data Provider	RESPONSE

","urlObject":{"protocol":"http","path":["api","query","{catalogId}","{dataProductId}","tabulate"],"host":["host"],"query":[{"description":{"content":"

Required - Flag specifying whether the total row count should be returned along side\nthe data.

\n","type":"text/plain"},"key":"count","value":""},{"description":{"content":"

Optional - Columns to use as dimensions.

\n","type":"text/plain"},"key":"dims","value":""},{"description":{"content":"

Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: MTNA Dataset MTNA Simple Dataset AM Charts Google Charts Plotly Bar Chart Plotly Boxplot Plotly Bubble Chart Plotly Histogram Plotly Pie Chart Plotly Scatterplot. Default value is MTNA Simple Dataset.

\n","type":"text/plain"},"key":"format","value":""},{"description":{"content":"

Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.

\n","type":"text/plain"},"key":"groupby","value":""},{"description":{"content":"

Required - Flag specifying if we want the values injected into the returned records.

\n","type":"text/plain"},"key":"inject","value":""},{"description":{"content":"

Optional - The limit of records to return.

\n","type":"text/plain"},"key":"limit","value":""},{"description":{"content":"

Optional - Columns to use as measures. Count is used by default.

\n","type":"text/plain"},"key":"measure","value":""},{"description":{"content":"

Required - Flag specifying whether metadata should be returned along side the data.

\n","type":"text/plain"},"key":"metadata","value":""},{"description":{"content":"

Optional - The record to start at.

\n","type":"text/plain"},"key":"offset","value":""},{"description":{"content":"

Optional - Allows the data to be reordered in ascending or descending order by column

\n","type":"text/plain"},"key":"orderby","value":""},{"description":{"content":"

Required - Flag specifying whether subtotals should be returned along side the data.

\n","type":"text/plain"},"key":"totals","value":""},{"description":{"content":"

Optional - The IDs of variables to use as weights in the resulting data.

\n","type":"text/plain"},"key":"weights","value":""},{"description":{"content":"

Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause

\n","type":"text/plain"},"key":"where","value":""}],"variable":[{"description":{"content":"

Required - The ID of the catalog that contains the data product.

\n","type":"text/plain"},"type":"string","value":"","key":"catalogId"},{"description":{"content":"

Required - The ID of the data product to query.

\n","type":"text/plain"},"type":"string","value":"","key":"dataProductId"}]}},"response":[{"id":"16795ec9-95aa-422f-9b2a-316c772a0106","name":"AM Charts","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":"{\n \"x\" : [ \"giraffes\", \"orangutans\", \"monkeys\" ],\n \"y\" : [ 20, 14, 23 ],\n \"type\" : \"bar\"\n }\n"},{"id":"6293ff7c-cf89-4338-bcb6-d37ef2747b75","name":"Plotly Bubble Chart","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":"{\n \"x\" : [ 1, 2, 3, 4 ],\n \"y\" : [ 10, 11, 12, 13 ],\n \"mode\" : \"markers\",\n \"marker\" : {\n \"size\" : [ 10, 10, 10, 10 ]\n }\n }"},{"id":"68aaa283-b2b6-4305-a366-9264b8e457c8","name":"Plotly Histogram","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":"{\n \"x\" : \"x0\",\n \"opacity\" : 0.75,\n \"type\" : \"histogram\"\n }\n"},{"id":"774e6609-26ba-4149-b4cd-0a938cc1d8e0","name":"Google Charts","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":"{\n \"cols\" : [ {\n \"id\" : \"CATS\",\n \"label\" : \"Number of cats\",\n \"type\" : \"string\"\n }, {\n \"id\" : \"DOGS\",\n \"label\" : \"Number of dogs\",\n \"type\" : \"string\"\n }, {\n \"id\" : \"BIRDS\",\n \"label\" : \"Number of birds\",\n \"type\" : \"string\"\n } ],\n \"rows\" : [ {\n \"c\" : [ {\n \"v\" : 1\n }, {\n \"v\" : 2\n }, {\n \"v\" : 4\n } ]\n }, {\n \"c\" : [ {\n \"v\" : 1\n }, {\n \"v\" : 1\n }, {\n \"v\" : 4\n } ]\n }, {\n \"c\" : [ {\n \"v\" : 1\n }, {\n \"v\" : 1\n }, {\n \"v\" : 4\n } ]\n } ]\n }"},{"id":"8251a2df-0c69-4e36-8704-8a16514fbfb1","name":"Plotly Pie Chart","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":" {\n \"labels\" : [ 1, 1, 1 ],\n \"type\" : \"pie\",\n \"values\" : [ 2, 1, 1 ]\n }\n"},{"id":"c32bf590-8cc5-4181-9659-6575d91d3f55","name":"MTNA Simple Dataset","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":" {\n \"info\" : {\n \"cached\" : false,\n \"columnCount\" : 2,\n \"columnOffset\" : 0,\n \"end\" : \"2019-06-26T20:10:42.210Z\",\n \"includeMetadata\" : true,\n \"moreColumns\" : false,\n \"moreRows\" : true,\n \"notes\" : [ ],\n \"postQueryTime\" : 0,\n \"preQueryTime\" : 98,\n \"queryTime\" : 1579,\n \"rowLimit\" : 3,\n \"rowOffset\" : 0,\n \"start\" : \"2019-06-26T20:10:40.533Z\",\n \"totalProcessingTime\" : 1677\n },\n \"records\" : [ [ 1, 2 ], [ 1, 1 ], [ 1, 1 ] ],\n \"totals\" : [ ],\n \"variables\" : [ {\n \"dataType\" : \"NUMERIC\",\n \"decimals\" : 0,\n \"endPosition\" : 2,\n \"fixedStorageWidth\" : 2,\n \"id\" : \"CATS\",\n \"isPrivate\" : false,\n \"label\" : \"NUMBER OF CATS\",\n \"name\" : \"CATS\",\n \"questionText\" : \"How many cats do you have?\",\n \"startPosition\" : 0,\n \"storageType\" : \"INT\",\n \"summaryStatistics\" : {\n \"dateProduced\" : \"2019-06-21T12:32:28.034Z\",\n \"sets\" : [ {\n \"distinctSet\" : [ ],\n \"max\" : 1,\n \"mean\" : 1,\n \"min\" : 1,\n \"missing\" : 0,\n \"populated\" : 662,\n \"standardDeviation\" : 0,\n \"weighted\" : false\n } ]\n },\n \"uri\" : \"c456\"\n }, {\n \"classificationUri\" : \"cx234\",\n \"dataType\" : \"NUMERIC\",\n \"decimals\" : 0,\n \"endPosition\" : 17,\n \"fixedStorageWidth\" : 1,\n \"frequencies\" : {\n \"dateProduced\" : \"2019-06-21T12:32:28.055Z\",\n \"sets\" : [ {\n \"map\" : {\n \"1\" : 182,\n \"2\" : 354,\n \"3\" : 126\n },\n \"weighted\" : false,\n \"weights\" : [ ]\n } ]\n },\n \"id\" : \"DOGS\",\n \"isPrivate\" : false,\n \"label\" : \"NUMBER OF DOGS\",\n \"name\" : \"DOGS\",\n \"questionText\" : \"How many dogs do you have?\",\n \"startPosition\" : 16,\n \"storageType\" : \"INT\",\n \"summaryStatistics\" : {\n \"dateProduced\" : \"2019-06-21T12:32:28.055Z\",\n \"sets\" : [ {\n \"distinctSet\" : [ ],\n \"max\" : 3,\n \"mean\" : 1.915,\n \"min\" : 1,\n \"missing\" : 0,\n \"populated\" : 662,\n \"standardDeviation\" : 0.677,\n \"weighted\" : false\n } ]\n },\n \"uri\" : \"123\"\n } ]\n }"},{"id":"c3a83916-2abe-4042-b4ee-4dbddf27b35a","name":"MTNA Dataset","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":"{\n \"classifications\" : [ ],\n \"dataSetInformation\" : {\n \"cached\" : false,\n \"columnCount\" : 2,\n \"columnOffset\" : 0,\n \"end\" : \"2019-06-26T20:04:47.104Z\",\n \"includeMetadata\" : true,\n \"moreColumns\" : false,\n \"moreRows\" : true,\n \"notes\" : [ ],\n \"postQueryTime\" : 0,\n \"preQueryTime\" : 87,\n \"queryTime\" : 1598,\n \"rowLimit\" : 3,\n \"rowOffset\" : 0,\n \"start\" : \"2019-06-26T20:04:45.419Z\",\n \"totalProcessingTime\" : 1685\n },\n \"recordLayout\" : {\n \"isPrivate\" : false,\n \"variables\" : [ {\n \"dataType\" : \"NUMERIC\",\n \"decimals\" : 0,\n \"endPosition\" : 2,\n \"fixedStorageWidth\" : 2,\n \"id\" : \"CATS\",\n \"isPrivate\" : false,\n \"label\" : \"NUMBER OF CATS\",\n \"name\" : \"CATS\",\n \"questionText\" : \"How many cats do you have?\",\n \"startPosition\" : 0,\n \"storageType\" : \"INT\",\n \"summaryStatistics\" : {\n \"dateProduced\" : \"2019-06-21T12:32:28.034Z\",\n \"sets\" : [ {\n \"distinctSet\" : [ ],\n \"max\" : 1,\n \"mean\" : 1,\n \"min\" : 1,\n \"missing\" : 0,\n \"populated\" : 662,\n \"standardDeviation\" : 0,\n \"weighted\" : false\n } ]\n },\n \"uri\" : \"3893482a-3f43r5f-234rrf3\"\n }, {\n \"classificationUri\" : \"23984fu-deu490u-aa7\",\n \"dataType\" : \"NUMERIC\",\n \"decimals\" : 0,\n \"endPosition\" : 17,\n \"fixedStorageWidth\" : 1,\n \"frequencies\" : {\n \"dateProduced\" : \"2019-06-21T12:32:28.055Z\",\n \"sets\" : [ {\n \"map\" : {\n \"1\" : 182,\n \"2\" : 354,\n \"3\" : 126\n },\n \"weighted\" : false,\n \"weights\" : [ ]\n } ]\n },\n \"id\" : \"DOGS\",\n \"isPrivate\" : false,\n \"label\" : \"NUMBER OF DOGS\",\n \"name\" : \"DOGS\",\n \"questionText\" : \"How many dogs do you have?\",\n \"startPosition\" : 16,\n \"storageType\" : \"INT\",\n \"summaryStatistics\" : {\n \"dateProduced\" : \"2019-06-21T12:32:28.055Z\",\n \"sets\" : [ {\n \"distinctSet\" : [ ],\n \"max\" : 3,\n \"mean\" : 1.915,\n \"min\" : 1,\n \"missing\" : 0,\n \"populated\" : 662,\n \"standardDeviation\" : 0.677,\n \"weighted\" : false\n } ]\n },\n \"uri\" : \"3893482a\"\n } ]\n },\n \"records\" : [ {\n \"data\" : [ {\n \"attributes\" : [ ],\n \"value\" : {\n \"value\" : 1,\n \"variable\" : {\n \"id\" : \"CATS\",\n \"isPrivate\" : false,\n \"name\" : \"CATS\",\n \"uri\" : \"3893482a-3f43r5f-234rrf3\"\n }\n }\n }, {\n \"attributes\" : [ ],\n \"value\" : {\n \"value\" : 2,\n \"variable\" : {\n \"id\" : \"DOGS\",\n \"isPrivate\" : false,\n \"name\" : \"DOGS\",\n \"uri\" : \"3893482a\"\n }\n }\n } ]\n }, {\n \"data\" : [ {\n \"attributes\" : [ ],\n \"value\" : {\n \"value\" : 1,\n \"variable\" : {\n \"id\" : \"CATS\",\n \"isPrivate\" : false,\n \"name\" : \"CATS\",\n \"uri\" : \"3893482a-3f43r5f-234rrf3\"\n }\n }\n }, {\n \"attributes\" : [ ],\n \"value\" : {\n \"value\" : 1,\n \"variable\" : {\n \"id\" : \"DOGS\",\n \"isPrivate\" : false,\n \"name\" : \"DOGS\",\n \"uri\" : \"3893482a\"\n }\n }\n } ]\n }, {\n \"data\" : [ {\n \"attributes\" : [ ],\n \"value\" : {\n \"value\" : 1,\n \"variable\" : {\n \"id\" : \"CATS\",\n \"isPrivate\" : false,\n \"name\" : \"CATS\",\n \"uri\" : \"3893482a-3f43r5f-234rrf3\"\n }\n }\n }, {\n \"attributes\" : [ ],\n \"value\" : {\n \"value\" : 1,\n \"variable\" : {\n \"id\" : \"DOGS\",\n \"isPrivate\" : false,\n \"name\" : \"DOGS\",\n \"uri\" : \"3893482a\"\n }\n }\n } ]\n } ],\n \"totals\" : [ ],\n \"variableGroups\" : [ ]\n }\n"},{"id":"d028e832-404c-4938-a1bc-0033ef168a23","name":"Plotly Scatterplot","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":"{\n \"x\" : [ 1, 2, 3, 4 ],\n \"y\" : [ 10, 15, 13, 17 ],\n \"type\" : \"scatter\"\n }"},{"id":"e65c00f6-c7bd-4392-9854-3968ebddfc99","name":"Plotly Boxplot","originalRequest":{"method":"GET","header":[],"url":{"raw":"http://host/api/query/{catalogId}/{dataProductId}/tabulate?count=&dims=&format=&groupby=&inject=&limit=&measure=&metadata=&offset=&orderby=&totals=&weights=&where=","protocol":"http","host":["host"],"path":["api","query","{catalogId}","{dataProductId}","tabulate"],"query":[{"key":"count","value":"","description":{"content":"Required - Flag specifying whether the total row count should be returned along side\nthe data.","type":"text/markdown"}},{"key":"dims","value":"","description":{"content":"Optional - Columns to use as dimensions.","type":"text/markdown"}},{"key":"format","value":"","description":{"content":"Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries. Possible Values: `MTNA Dataset` `MTNA Simple Dataset` `AM Charts` `Google Charts` `Plotly Bar Chart` `Plotly Boxplot` `Plotly Bubble Chart` `Plotly Histogram` `Plotly Pie Chart` `Plotly Scatterplot`. Default value is `MTNA Simple Dataset`.","type":"text/markdown"}},{"key":"groupby","value":"","description":{"content":"Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.","type":"text/markdown"}},{"key":"inject","value":"","description":{"content":"Required - Flag specifying if we want the values injected into the returned records.","type":"text/markdown"}},{"key":"limit","value":"","description":{"content":"Optional - The limit of records to return.","type":"text/markdown"}},{"key":"measure","value":"","description":{"content":"Optional - Columns to use as measures. Count is used by default.","type":"text/markdown"}},{"key":"metadata","value":"","description":{"content":"Required - Flag specifying whether metadata should be returned along side the data.","type":"text/markdown"}},{"key":"offset","value":"","description":{"content":"Optional - The record to start at.","type":"text/markdown"}},{"key":"orderby","value":"","description":{"content":"Optional - Allows the data to be reordered in ascending or descending order by column","type":"text/markdown"}},{"key":"totals","value":"","description":{"content":"Required - Flag specifying whether subtotals should be returned along side the data.","type":"text/markdown"}},{"key":"weights","value":"","description":{"content":"Optional - The IDs of variables to use as weights in the resulting data.","type":"text/markdown"}},{"key":"where","value":"","description":{"content":"Optional - The where parameter allows filters to be applied to the data that will be returned. This follows a syntax similar to a SQL where clause","type":"text/markdown"}}],"variable":[{"key":"catalogId","value":"","description":{"content":"Required - The ID of the catalog that contains the data product.","type":"text/markdown"}},{"key":"dataProductId","value":"","description":{"content":"Required - The ID of the data product to query.","type":"text/markdown"}}]},"description":"\n

"},"status":"Successful request","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json","disabled":false}],"cookie":[],"responseTime":null,"body":" {\n \"y\" : [ 0, 1, 1, 2, 3, 5, 8, 13, 21 ],\n \"boxpoints\" : \"all\",\n \"jitter\" : 0.3,\n \"pointpos\" : -1.8,\n \"type\" : \"box\"\n }"}],"_postman_id":"2b8d7357-ec90-4740-b05d-ec8ef86c07b4"},{"name":"Run select query.","id":"0815edb6-724c-42e6-9156-eaf04068f8a9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{host}}/rds/api/query/{catalogId}/{dataProductId}/select?collimit=&coloffset=&cols=&count=&format=&groupby=&inject=&limit=&lock=&metadata=&offset=&orderby=&weights=&where=","description":"

\nRunning a select query on the specified data product returns record level\nmicrodata. A variety of querying techniques can be used to subset,\ncompute, order, filter and format the results.\n

\n\n

Related Models

The following models are used in this request. View the model documentation to learn more about what it is and how it fits into this and other requests

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Model	Location
MTNA Data Set	RESPONSE
Plotly Box Plot	RESPONSE
RDS Data Set	RESPONSE
Plotly Bubble Chart	RESPONSE
Plotly Bar Chart	RESPONSE
Plotly Pie Chart	RESPONSE
Plotly Histogram	RESPONSE
Google Chart Data Set	RESPONSE
AmCharts Data Provider	RESPONSE

","urlObject":{"path":["rds","api","query","{catalogId}","{dataProductId}","select"],"host":["{{host}}"],"query":[{"description":{"content":"

Optional - Limits the number of columns returned.

\n","type":"text/plain"},"key":"collimit","value":""},{"description":{"content":"

Optional - Determines which column to start at.

\n","type":"text/plain"},"key":"coloffset","value":""},{"description":{"content":"

Optional - Column names, regular expressions, key words, variable groups, or concepts to select. Any of these can be excluded as well by prepending '~' to these syntaxes.

\n","type":"text/plain"},"key":"cols","value":""},{"description":{"content":"

Optional - Flag specifying whether the total row count should be returned along side\nthe data.

\n","type":"text/plain"},"key":"count","value":""},{"description":{"content":"

Optional - RDS can return a variety of JSON objects to plug into various java script\ncharting libraries, if none is specified, 'RDS' will be set by default. Possible Values: AMCHARTS, DENODO, GCHARTS, RDS, MTNA, MTNA_TABULATE, PLOTLY_AREA, PLOTLY_BAR, PLOTLY_BOXPLOT, PLOTLY_BUBBLE, PLOTLY_HIST, PLOTLY_H_BAR, PLOTLY_H_HIST, PLOTLY_LINE, PLOTLY_PIE, PLOTLY_SCATTER, PLOTLY_TS, TABLEAU.

\n","type":"text/plain"},"key":"format","value":""},{"description":{"content":"

Optional - When computing a new variable using a function that depends onaggregation the group by parameter can specify which columns to group by.

\n","type":"text/plain"},"key":"groupby","value":""},{"description":{"content":"

Optional - Flag specifying to inject codes into the returned records.

\n","type":"text/plain"},"key":"inject","value":""},{"description":{"content":"

Optional - The limit of records to return.

\n","type":"text/plain"},"key":"limit","value":""},{"description":{"content":"

Optional - Column names, regular expressions, key words, variable groups, or\nconcepts to lock. These will be returned first adn listed out in\nDataSetInformation that is returned on the DataSet.

\n","type":"text/plain"},"key":"lock","value":""},{"description":{"content":"

Optional - Flag specifying if metadata should be returned along side the data.