Datastore API issue

[DaniyalRaza786]

I want to fetch all the data from the resource files at once. So we tried /API/1/datastore/query with the 'GET' method as mentioned in the documentation, but it gave an empty result on the demo.getdkan.com website. How can I resolve this issue? And the second thing is datastore API show only CSV file's data, but we need to show CSV and excel file how can I fetch for both file data at a time if have any possibilities please suggest me.

PFA

[dafeder]

Hi @DaniyalRaza786. You need to provide an identifier to the datastore API so that it can know what table to show. Usually this is done by adding it directly to the endpoint, so api/1/datastore/query/[distribution-id] or api/1/datastore/query/[dataset-id]/[index] - the index being which number in the distribution array your table occupies (often "0").

So for instance for

https://demo.getdkan.org/dataset/5dc1cfcf-8028-476c-a020-f58ec6dd621c

We can query

https://demo.getdkan.org/api/1/datastore/query/5dc1cfcf-8028-476c-a020-f58ec6dd621c/0

The datastore can only run queries on resources that have been imported to the database. At the moment, DKAN can only import CSV files.

[dafeder]

Closing this, assuming its resolved