{"_id":"556e0fbfc9d85a1900914cb7","__v":4,"category":{"_id":"556e0f23d02e0b190042f13d","__v":13,"version":"553591cd63cc650d00312925","pages":["556e0fbfc9d85a1900914cb7","556e12e6c9d85a1900914ccd","556e55f1d02e0b190042f20f","556e564c3f11b01900a36a35","556e6440d02e0b190042f22e","556f5a8c9893290d00988c3c","556f5c72ebba950d008e94bc","556f6f73ebba950d008e952e","5571d2c91cd8283500a8b48b","5571f0b86d8908230061f42b","5571f3df6d8908230061f448","557853bbe6063e0d004816fb","557859b727f77c0d00fe61a2"],"project":"55357364e02d480d0003c6d3","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-06-02T20:16:35.357Z","from_sync":false,"order":8,"slug":"data-sources","title":"Data Sources"},"user":"55359b006dfbb90d003462b5","project":"55357364e02d480d0003c6d3","version":{"_id":"553591cd63cc650d00312925","project":"55357364e02d480d0003c6d3","__v":13,"forked_from":"55357365e02d480d0003c6d6","createdAt":"2015-04-20T23:54:53.134Z","releaseDate":"2015-04-20T23:54:53.134Z","categories":["553591cd63cc650d00312926","553591cd63cc650d00312927","5536e4d39f7f2d0d00b1cd54","5536e55c20d5ca0d0001580a","5536e6bf7fe60f0d000fd1c0","5536f5bba171250d00c00556","553a974369c2630d00a8562e","553a97c60074c80d00621c2a","553a98332af5f20d000fc32a","553a9b9869c2630d00a85642","556e0f23d02e0b190042f13d","563249b1dcc27a1700823650","5639113f049e420d00476b03","59a5dd94aaa11d003334edb4"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"2.0.0","version":"2"},"editedParams":true,"editedParams2":true,"parentDoc":null,"updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-06-02T20:19:11.314Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[{"language":"json","code":"[\n  {\n    \"id\": \"864ccc97-76cb-4cf0-8099-a46c0108d3ca\",\n    \"keyColumn\": \"Madison Care Center\",\n    \"value\": \"[\\\"1391 East Madison Avenue\\\",\\\"El Cajon\\\",\\\"CA\\\",\\\"92021-8568\\\",\\\"619-444-1107\\\",\\\"Emmanuel\\\",\\\"David\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/864ccc97-76cb-4cf0-8099-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"ce44494c-fe3e-438e-8238-a46c0108d3ca\",\n    \"keyColumn\": \"Country Hills Health Care Inc.\",\n    \"value\": \"[\\\"1580 Broadway\\\",\\\"El Cajon\\\",\\\"CA\\\",\\\"92021-5124\\\",\\\"619-441-8745\\\",\\\"Glen\\\",\\\"Larson\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/ce44494c-fe3e-438e-8238-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"deba9712-1fe5-44e6-83c6-a46c0108d3ca\",\n    \"keyColumn\": \"Scripps Mem Hosp - Encinatas\",\n    \"value\": \"[\\\"P O Box 230817\\\",\\\"Encinitas\\\",\\\"CA\\\",\\\"92023-0817\\\",\\\"760-753-6501\\\",\\\"Rebecca\\\",\\\"Ropchan\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/deba9712-1fe5-44e6-83c6-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"20946663-8560-4343-8872-a46c0108d3ca\",\n    \"keyColumn\": \"Scripps Memorial Hospital\",\n    \"value\": \"[\\\"435 H Street\\\",\\\"Chula Vista\\\",\\\"CA\\\",\\\"91910-4307\\\",\\\"619-691-7000\\\",\\\"Aldo\\\",\\\"Ferrer\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/20946663-8560-4343-8872-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"40bc4d21-c424-4ed8-8c5f-a46c0108d3ca\",\n    \"keyColumn\": \"Graybill Medical Group Inc.\",\n    \"value\": \"[\\\"225 East 2ND Avenue\\\",\\\"Escondido\\\",\\\"CA\\\",\\\"92025-4249\\\",\\\"760-291-6700\\\",\\\"Marvin\\\",\\\"Beddoe\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/40bc4d21-c424-4ed8-8c5f-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"8a4ad6f1-fa95-4f61-96d7-a46c0108d3ca\",\n    \"keyColumn\": \"Southbay Respite\",\n    \"value\": \"[\\\"1105 Broadway Ste. 206\\\",\\\"Chula Vista\\\",\\\"CA\\\",\\\"91911-2767\\\",\\\"619-422-1311\\\",\\\"Katie\\\",\\\"Santillian\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/8a4ad6f1-fa95-4f61-96d7-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"cca05b75-52c8-4fd2-9c75-a46c0108d3ca\",\n    \"keyColumn\": \"Southwood Treatment Centers\",\n    \"value\": \"[\\\"330 Moss Street\\\",\\\"Chula Vista\\\",\\\"CA\\\",\\\"91911-2005\\\",\\\"619-426-6310\\\",\\\"Jack\\\",\\\"Lungu\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/cca05b75-52c8-4fd2-9c75-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"107deede-ee6e-490b-9e5a-a46c0108d3ca\",\n    \"keyColumn\": \"Fredericka Manor Care Center\",\n    \"value\": \"[\\\"111 3RD Avenue\\\",\\\"Chula Vista\\\",\\\"CA\\\",\\\"91910-1822\\\",\\\"619-427-2777\\\",\\\"Vito\\\",\\\"Genna\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/107deede-ee6e-490b-9e5a-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"60fa007e-9ee0-4fb8-a3e5-a46c0108d3ca\",\n    \"keyColumn\": \"Heritage Senior Care\",\n    \"value\": \"[\\\"2885 Hope Avenue\\\",\\\"Carlsbad\\\",\\\"CA\\\",\\\"92008-1833\\\",\\\"760-720-7740\\\",\\\"Ronnie\\\",\\\"Mayben\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/60fa007e-9ee0-4fb8-a3e5-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"a84bf9aa-ce71-46fb-a5ca-a46c0108d3ca\",\n    \"keyColumn\": \"Casa Palmera Care Center\",\n    \"value\": \"[\\\"14750 El Camino Real\\\",\\\"Del Mar\\\",\\\"CA\\\",\\\"92014-4204\\\",\\\"858-481-4411\\\",\\\"Lee\\\",\\\"Johnson\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/a84bf9aa-ce71-46fb-a5ca-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"b03e76f7-f960-4d11-af18-a46c0108d3ca\",\n    \"keyColumn\": \"Family Practice Assc San Diego\",\n    \"value\": \"[\\\"860 Jamacha Road Ste. 103\\\",\\\"El Cajon\\\",\\\"CA\\\",\\\"92019-3225\\\",\\\"619-579-1383\\\",\\\"Sol\\\",\\\"Lizerbram\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/b03e76f7-f960-4d11-af18-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"db26b71e-445a-467c-b052-a46c0108d3ca\",\n    \"keyColumn\": \"Faith Jones Assoc\",\n    \"value\": \"[\\\"7330 Golden Star Lanes\\\",\\\"Carlsbad\\\",\\\"CA\\\",\\\"92009-4852\\\",\\\"760-438-8800\\\",\\\"Norman\\\",\\\"Jones\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/db26b71e-445a-467c-b052-a46c0108d3ca\"\n  },\n  {\n    \"id\": \"1bc402b5-3384-474e-b1e3-a46c0108d3ca\",\n    \"keyColumn\": \"Community Health Group\",\n    \"value\": \"[\\\"740 Bay Boulevard\\\",\\\"Chula Vista\\\",\\\"CA\\\",\\\"91910-5299\\\",\\\"619-422-0422\\\",\\\"Norma\\\",\\\"Diaz\\\"]\",\n    \"url\": \"https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows/1bc402b5-3384-474e-b1e3-a46c0108d3ca\"\n  }\n]","name":"","status":200},{"status":400,"language":"json","code":"{\n  \"code\": 400,\n  \"status\": \"Bad Request\",\n  \"message\": \"PageNumber should be an integer\",\n  \"requestUrl\": \"http://localhost:27060/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows?pagenumber=rrrrrr\",\n  \"requestId\": \"de2e173d-28be-4282-a76e-9bcf3d20bd9b\"\n}","name":""}]},"settings":"","examples":{"codes":[{"language":"text","code":"GET https://api.goformz.com/v2/datasources/916e237e-7aa5-4df2-8624-e336fb91b6bf/rows?pageSize=100&sort=keyColumn%20asc","name":"Url"}]},"method":"get","auth":"required","params":[{"_id":"556e1242c9d85a1900914cc3","ref":"","in":"path","required":true,"desc":"id of the data source","default":"","type":"string","name":"dataSourceId"},{"_id":"556e112dd02e0b190042f142","ref":"","in":"query","required":false,"desc":"The field name to sort on, optionally you can specify a direction (asc or desc).","default":"","type":"string","name":"sort"},{"_id":"556e112dd02e0b190042f141","ref":"","in":"query","required":false,"desc":"Returns only data source rows where the key column starts with the specified string.","default":"","type":"string","name":"name"}],"url":"/datasources/{dataSourceId}/rows"},"isReference":false,"order":8,"body":"Returns the paginated result from the specified parameters. See <a href=\"http://developers.goformz.com/docs/pagination\" alt=\"pagination\">Pagination</a> for more details.\n\n</br><a href=\"https://api.goformz.com/docs/api/explorer/index#!/DataSources/DataSources_GetRows\" target=\"_blank\"><img src=\"https://files.readme.io/9Z82WIZnS7mZmco8oi4u_TryItNow3.png\" style=\"margin-left:15px\" width=\"128\" height=\"42\" ></a>","excerpt":"","slug":"get-a-list-of-data-source-rows","type":"endpoint","title":"Get a List of Data Source Rows"}

getGet a List of Data Source Rows


Definition

{{ api_url }}{{ page_api_url }}

Parameters

Path Params

dataSourceId:
required
string
id of the data source

Query Params

sort:
string
The field name to sort on, optionally you can specify a direction (asc or desc).
name:
string
Returns only data source rows where the key column starts with the specified string.

Examples


Result Format


Documentation

Returns the paginated result from the specified parameters. See <a href="http://developers.goformz.com/docs/pagination" alt="pagination">Pagination</a> for more details. </br><a href="https://api.goformz.com/docs/api/explorer/index#!/DataSources/DataSources_GetRows" target="_blank"><img src="https://files.readme.io/9Z82WIZnS7mZmco8oi4u_TryItNow3.png" style="margin-left:15px" width="128" height="42" ></a>