ODK aggregate pull data with ODK Briefcase API

[Katha_Chowdhury]

1. What is the issue? Please be detailed.

2. What steps can we take to reproduce this issue?

3. What have you tried to fix the issue?

4. Upload any test forms or screenshots below.

i am trying to pull out the data of a for from odk aggregate,

basically the below end point is supposablely known to pull out the instances where form submissions data is , but its giving 400 error

https://oiosodkdev.cag.gov.in/ODKAggregate/view/submissionList?formId=DCTK-1001_DC-1015_Test&cursor=&numEntries=10

i am making a get call with GET and Content-Type is text/xml

can you tell where i am going wrong

[danbjoseph]

Please note that Aggregate is no longer being supported. Central is now the ODK server. We recommend you upgrade if possible to ensure proper functioning and security. The documentation provides instructions for different ways to set up Central. Also, Get ODK provides reliable paid cloud hosting.

The post below has for more details about the end-of-life for Aggregate.

Aggregate is no longer being updated

In accordance with the plans announced at Upcoming changes to Aggregate, the core team is no longer updating Aggregate. We will not fix bugs, add features, review PRs, improve documentation, release new versions, or answer support questions. We've been communicating this reality to users over the last two years through the documentation, code repo, and in community announcements. The core team (and the @TAB) believe that Central is production ready and better than Aggregate for most users, so …

However, someone on the forum may still be able to help you.

• What version of Aggregate are you using?
• Are you hosting your Aggregate on Google App Engine? Do you have a paid account or only the free level?
• Are you providing a token or credentials in your API call?
• Your URL query includes an empty cursor parameter?

[Katha_Chowdhury]

end point is
https://oiosodkdev.cag.gov.in/ODKAggregate/view/submissionList?formId=DCTK-1001_DC-1015_Test&cursor=&numEntries=10 where i do not have any value of cursor given , and i do not have any user name and password in it , do i need it where it has to be given can you pls help

the headers is at present on Content-Type is text/xml , and its giving 400 error making a get call made in axios , i am trying to programmatically extract the data in aggregate , and the use the submission rest api to make the data go in central, that my aim.

[Katha_Chowdhury]

[danbjoseph]

I am not very familiar with Aggregate. Have you reviewed both of these documentation pages?

• https://docs.getodk.org/aggregate-data-access/
• https://github.com/getodk/getodk/wiki/Briefcase-Aggregate-API

Transferring data from Aggregate to Central is discussed a little in this post:

Briefcase: pull from Aggregate and then push to Central

Recently @aurdipas brought up that it is critical to have a path to restore an Aggregate backup to Central for data collection campaigns that are long-running. First, if you need to transfer data from Aggregate to Central, I'd like to hear more about your scenario. How long is your data collection campaign? Why are you considering the switch before completing your current data collection campaign? I have been working to make Briefcase able to serve this need. Briefcase push to Central has never…

[Katha_Chowdhury]

yes i am following all the above that you mentioned , but where to put user name and password of odk aggregate.

[danbjoseph]

Did you have success with any other API calls to your Aggregate server?
How did you get the formId value?
Does the error response have any additional details attached?

[Katha_Chowdhury]

no , other api i have not tried, i am trying meanwhile , will keep you posted, the form id , is the form name , that is there in ODK aggregate of our dev server, that's how i got it,

[Katha_Chowdhury]

is there a rest end points how to see the complete list of projects aggregate has, and the in then in each project what all are the available forms in them , and download the corresponding form definitions , from aggregate.

[LN]

@Katha_Chowdhury

where to put user name and password of odk aggregate.

Aggregate uses Basic Auth. The Authorization tab in Postman Should let you specify a type of Basic Auth and then prompt you to include your credentials.

Make sure you also follow the OpenRosa spec. You will need to specify the headers described there.

@Katha_Chowdhury

the complete list of projects aggregate has

Aggregate does not have a project concept. My recollection is that the only way to get a list of forms is through the formList OpenRosa endpoint. That will not included closing or closed forms.