@Jcook
Below is the design and output of get rows
CREATE TABLE FXRateSample(
[FXRateCollectionId] [bigint] NOT NULL,
[SampleDate] [date] NOT NULL,
[SampleValue] [float] NULL,
PRIMARY KEY CLUSTERED
(
[FXRateCollectionId] ASC,
[SampleDate] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
{"statusCode":200,"headers":{"Pragma":"no-cache","Transfer-Encoding":"chunked","Vary":"Accept-Encoding","x-ms-request-id":"331e7336-ce91-4e5a-94f1-541656d4640f","Strict-Transport-Security":"max-age=31536000; includeSubDomains","X-Content-Type-Options":"nosniff","X-Frame-Options":"DENY","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","Cache-Control":"no-store, no-cache","Date":"Wed, 21 Oct 2020 13:55:18 GMT","Content-Type":"application/json; charset=utf-8; odata.metadata=minimal","Expires":"-1","Content-Length":"8766"},"body":{"@odata.context":"https://flow-apim-europe-001-francecentral-01.azure-apim.net/apim/sql/shared-sql-398b787c-a776-43fc-9ebe-71ef-086faf97/$metadata#datasets('default%2Cdefault')/tables('%5Bdbo%5D.%5BFXRateSample%5D')/items","value":[{"@odata.etag":"","ItemInternalId":"e74ed7b1-7a2e-4f15-a41f-1feb6b3ff59a","SampleValue":1.0,"FXRateCollectionId":0,"SampleDate":"2010-01-01"},{"@odata.etag":"","ItemInternalId":"f9085f4e-2515-4fc7-ac73-3d05deb8efa5","SampleValue":1.679924,"FXRateCollectionId":1,"SampleDate":"2014-04-26"},{"@odata.etag":"","ItemInternalId":"62cd89e6-29c8-4faf-9c34-9e35a7b9fec7","SampleValue":1.679896,"FXRateCollectionId":1,"SampleDate":"2014-04-27"},{"@odata.etag":"","ItemInternalId":"77621ad4-5751-4119-87eb-09f161e2063a","SampleValue":1.680545,"FXRateCollectionId":1,"SampleDate":"2014-04-28"},{"@odata.etag":"","ItemInternalId":"c1f175b8-7725-44cc-8a4f-ce8ce73751f4","SampleValue":1.68745,"FXRateCollectionId":1,"SampleDate":"2014-08-06"},{"@odata.etag":"","ItemInternalId":"fef1d61d-62db-40c4-9ee5-02c00c0a5822","SampleValue":1.685616,"FXRateCollectionId":1,"SampleDate":"2014-08-07"},{"@odata.etag":"","ItemInternalId":"33ea2288-3f2a-4b07-a5d1-8d651ef95454","SampleValue":1.683388,"FXRateCollectionId":1,"SampleDate":"2014-08-08"},{"@odata.etag":"","ItemInternalId":"87b1b5f4-ec83-407a-a692-ccefc1686645","SampleValue":1.677965,"FXRateCollectionId":1,"SampleDate":"2014-08-09"},{"@odata.etag":"","ItemInternalId":"1fefe795-7a20-4f66-988d-227c1dad5373","SampleValue":1.532743,"FXRateCollectionId":1,"SampleDate":"2015-01-04"},{"@odata.etag":"","ItemInternalId":"491d4ec4-31f0-4eb0-a13f-db0a8b115b0d","SampleValue":1.506852,"FXRateCollectionId":1,"SampleDate":"2015-02-01"},{"@odata.etag":"","ItemInternalId":"99728692-b521-4ec6-99ed-9e8e476bb985","SampleValue":1.543508,"FXRateCollectionId":1,"SampleDate":"2015-03-01"},{"@odata.etag":"","ItemInternalId":"350a1052-cfb3-4988-a853-a8f9cb6cd561","SampleValue":1.483944,"FXRateCollectionId":1,"SampleDate":"2015-04-01"},{"@odata.etag":"","ItemInternalId":"6959f3c2-6238-4101-a781-164dd2e3496e","SampleValue":1.532414,"FXRateCollectionId":1,"SampleDate":"2015-05-01"},{"@odata.etag":"","ItemInternalId":"ab0408a7-2526-4cc1-b67c-17b56b0f3d90","SampleValue":1.529157,"FXRateCollectionId":1,"SampleDate":"2015-06-01"},{"@odata.etag":"","ItemInternalId":"7d354349-576c-42fa-998d-2187327ebef3","SampleValue":1.573317,"FXRateCollectionId":1,"SampleDate":"2015-07-01"},{"@odata.etag":"","ItemInternalId":"3674b935-3e6a-41b5-b602-5daca2c2014a","SampleValue":1.563404,"FXRateCollectionId":1,"SampleDate":"2015-08-01"},{"@odata.etag":"","ItemInternalId":"f7d527e4-030d-4028-a62b-eb0ec8bad295","SampleValue":1.534743,"FXRateCollectionId":1,"SampleDate":"2015-09-01"},{"@odata.etag":"","ItemInternalId":"2d6dfd48-465c-4422-a38b-2cd003f9df70","SampleValue":1.513546,"FXRateCollectionId":1,"SampleDate":"2015-10-01"},{"@odata.etag":"","ItemInternalId":"2747137e-d661-48de-a8b1-90da0728cbf0","SampleValue":1.542603,"FXRateCollectionId":1,"SampleDate":"2015-11-01"},{"@odata.etag":"","ItemInternalId":"150110c8-6605-4a06-9aa7-4fb702bf315c","SampleValue":1.504902,"FXRateCollectionId":1,"SampleDate":"2015-12-01"},{"@odata.etag":"","ItemInternalId":"9a069620-ac5e-4de2-8443-15f9819b9b8d","SampleValue":1.473839,"FXRateCollectionId":1,"SampleDate":"2016-01-01"},{"@odata.etag":"","ItemInternalId":"9b536d53-fbbb-4916-a9cf-b213fd83dc7f","SampleValue":1.424501,"FXRateCollectionId":1,"SampleDate":"2016-02-01"},{"@odata.etag":"","ItemInternalId":"03e41ebe-305f-4e8f-921b-55deb36ddc69","SampleValue":1.392157,"FXRateCollectionId":1,"SampleDate":"2016-03-01"},{"@odata.etag":"","ItemInternalId":"b9c136bc-2d66-4454-86b6-9e3c6c743e4b","SampleValue":1.439263,"FXRateCollectionId":1,"SampleDate":"2016-04-01"},{"@odata.etag":"","ItemInternalId":"8519a2d3-ade4-41ee-8bbc-0561eaebe4cd","SampleValue":1.46155,"FXRateCollectionId":1,"SampleDate":"2016-05-01"},{"@odata.etag":"","ItemInternalId":"bdbae70c-c593-472f-be8b-63827682fa29","SampleValue":1.449433,"FXRateCollectionId":1,"SampleDate":"2016-06-01"},{"@odata.etag":"","ItemInternalId":"3461ef17-8e6f-4635-b236-97f613dfccca","SampleValue":1.32318,"FXRateCollectionId":1,"SampleDate":"2016-07-01"},{"@odata.etag":"","ItemInternalId":"62e82275-a9ba-4b5c-9cdb-d092e7b83151","SampleValue":1.322953,"FXRateCollectionId":1,"SampleDate":"2016-08-01"},{"@odata.etag":"","ItemInternalId":"9ab1a40d-c6ab-4639-98b9-e9cc8d15d4ec","SampleValue":1.31337,"FXRateCollectionId":1,"SampleDate":"2016-09-01"},{"@odata.etag":"","ItemInternalId":"c0fb33d4-ab54-4e09-af9d-fe55a155c4ab","SampleValue":1.297859,"FXRateCollectionId":1,"SampleDate":"2016-10-01"},{"@odata.etag":"","ItemInternalId":"82b2fe8e-0059-424a-8d80-2bb9bf5c6ae9","SampleValue":1.222793,"FXRateCollectionId":1,"SampleDate":"2016-11-01"},{"@odata.etag":"","ItemInternalId":"2bb806a3-4878-440c-944c-7f730d89738f","SampleValue":1.25897,"FXRateCollectionId":1,"SampleDate":"2016-12-01"},{"@odata.etag":"","ItemInternalId":"00def3e2-94fc-409b-ba9c-63ae7f1b076c","SampleValue":1.233905,"FXRateCollectionId":1,"SampleDate":"2017-01-01"},{"@odata.etag":"","ItemInternalId":"a825ad03-6c28-497e-b1f3-e38818620dda","SampleValue":1.263775,"FXRateCollectionId":1,"SampleDate":"2017-02-01"},{"@odata.etag":"","ItemInternalId":"3b235126-3574-463a-89cc-edbbc5c20d30","SampleValue":1.232438,"FXRateCollectionId":1,"SampleDate":"2017-03-01"},{"@odata.etag":"","ItemInternalId":"e2044d50-6231-419d-899f-36af23c002cb","SampleValue":1.254398,"FXRateCollectionId":1,"SampleDate":"2017-04-02"},{"@odata.etag":"","ItemInternalId":"699c750d-2612-48de-9ea0-29c707e9b3a4","SampleValue":1.3522,"FXRateCollectionId":1,"SampleDate":"2018-01-01"},{"@odata.etag":"","ItemInternalId":"cc914147-ea6b-463d-ba83-cdf6bfad8fbc","SampleValue":1.4268,"FXRateCollectionId":1,"SampleDate":"2018-02-01"},{"@odata.etag":"","ItemInternalId":"86ddb4b5-164c-4737-a525-c10988d1bd46","SampleValue":1.3771,"FXRateCollectionId":1,"SampleDate":"2018-03-01"},{"@odata.etag":"","ItemInternalId":"efbe9000-c21d-412e-bb11-927a57b8bbba","SampleValue":1.4042,"FXRateCollectionId":1,"SampleDate":"2018-04-02"},{"@odata.etag":"","ItemInternalId":"2dfc1589-4c63-4148-ae3c-23c6658fd378","SampleValue":1.3615,"FXRateCollectionId":1,"SampleDate":"2018-05-01"},{"@odata.etag":"","ItemInternalId":"80d70ddd-a59d-4418-9d05-04b5ca0fa18d","SampleValue":1.23,"FXRateCollectionId":1,"SampleDate":"2019-08-23"},{"@odata.etag":"","ItemInternalId":"1f75f250-bdcf-456f-98e9-074acf71cbe7","SampleValue":0.7743377906,"FXRateCollectionId":1,"SampleDate":"2020-10-16"},{"@odata.etag":"","ItemInternalId":"cf6f554a-504f-4a5c-964c-68f1276712dc","SampleValue":0.773319221,"FXRateCollectionId":1,"SampleDate":"2020-10-20"},{"@odata.etag":"","ItemInternalId":"fbb1d75a-a7bb-40c6-aa4e-46b2b97b44e3","SampleValue":1.2012,"FXRateCollectionId":2,"SampleDate":"2018-01-01"},{"@odata.etag":"","ItemInternalId":"889da319-c694-4031-a783-660730721d42","SampleValue":1.251,"FXRateCollectionId":2,"SampleDate":"2018-02-01"},{"@odata.etag":"","ItemInternalId":"1ed976ed-4f57-4e00-b39a-ef5707bd02eb","SampleValue":1.2271,"FXRateCollectionId":2,"SampleDate":"2018-03-01"},{"@odata.etag":"","ItemInternalId":"07f532ff-b42e-4d1b-b881-5dbbf74c00a2","SampleValue":1.1,"FXRateCollectionId":2,"SampleDate":"2019-08-23"},{"@odata.etag":"","ItemInternalId":"6859a7b8-2126-49a6-acff-56741ae1ce7f","SampleValue":0.8517162082,"FXRateCollectionId":2,"SampleDate":"2020-10-16"},{"@odata.etag":"","ItemInternalId":"aee38abe-553d-4498-a522-8d523a37301c","SampleValue":0.8467400508,"FXRateCollectionId":2,"SampleDate":"2020-10-20"},{"@odata.etag":"","ItemInternalId":"4d0f65ac-a2c0-4feb-8c6a-7269bfba2f0c","SampleValue":0.89,"FXRateCollectionId":3,"SampleDate":"2019-09-05"},{"@odata.etag":"","ItemInternalId":"a95b6f41-fc77-4565-94d1-d88d953537e1","SampleValue":1.0999285046,"FXRateCollectionId":3,"SampleDate":"2020-10-16"},{"@odata.etag":"","ItemInternalId":"088b313c-2915-4248-b310-47f686421634","SampleValue":1.0949424608,"FXRateCollectionId":3,"SampleDate":"2020-10-20"}]}}
