FW: Access Tracker capture program stage data through API

Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,

Georgi

image

···

From: Georgi Chakarov

Sent: Monday, February 5, 2018 6:20 PM

To: ‘DHIS 2 Developers list’ dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net

Cc: Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Access Tracker capture program stage data through API

Hi all,

Can anyone tell me what is the query to read all data entered in a Tracker capture program stage?

We have tried this:

/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc

and other versions like /api/26/events.json?orgUnit=YuQRtpLP10I&ouMode=CHILDREN but we get the result below. Your feedback is highly appreciated!

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net

Just a thought - is the user you are using for the API member of the user group for which this data has been shared?

Knut

image

···

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,

Georgi

From: Georgi Chakarov

Sent: Monday, February 5, 2018 6:20 PM

To: ‘DHIS 2 Developers list’ dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net

Cc: Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Access Tracker capture program stage data through API

Hi all,

Can anyone tell me what is the query to read all data entered in a Tracker capture program stage?

We have tried this:

/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc

and other versions like /api/26/events.json?orgUnit=YuQRtpLP10I&ouMode=CHILDREN but we get the result below. Your feedback is highly appreciated!

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Hi Knut,

I am using a super user account and we don’t have data shared among users. Maybe the problem is related to the fact that Tracker data does not get exported in any format from the Import/Export app either. Aggregate data does, but tracker or event data does not.

Georgi

image

···

Just a thought - is the user you are using for the API member of the user group for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,

Georgi

From: Georgi Chakarov

Sent: Monday, February 5, 2018 6:20 PM

To: ‘DHIS 2 Developers list’ dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net

Cc: Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Access Tracker capture program stage data through API

Hi all,

Can anyone tell me what is the query to read all data entered in a Tracker capture program stage?

We have tried this:

/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc

and other versions like /api/26/events.json?orgUnit=YuQRtpLP10I&ouMode=CHILDREN but we get the result below. Your feedback is highly appreciated!

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Knut Staring

Department of Information, Evidence and Research

World Health Organization, Geneva, Switzerland

Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522

Skype: knutstar

Hi,

We have some guide on how to read events through api. See the documentation here.

https://docs.dhis2.org/master/en/developer/html/dhis2_developer_manual_full.html#webapi_querying_reading_events

and an example

https://play.dhis2.org/dev/api/28/events.json?orgUnit=DiszpKrYNg8&programStage=Zj7UnCAulEk&pageSize=50&page=1&totalPages=true

image

···

On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi Knut,

I am using a super user account and we don’t have data shared among users. Maybe the problem is related to the fact that Tracker data does not get exported in any format from the Import/Export app either. Aggregate data does, but tracker or event data does not.

Georgi

From: Knut Staring [mailto:knutst@gmail.com]

Sent: Tuesday, February 6, 2018 3:42 PM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: DHIS 2 Developers list dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net; Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

Just a thought - is the user you are using for the API member of the user group for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,

Georgi

From: Georgi Chakarov

Sent: Monday, February 5, 2018 6:20 PM

To: ‘DHIS 2 Developers list’ dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net

Cc: Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Access Tracker capture program stage data through API

Hi all,

Can anyone tell me what is the query to read all data entered in a Tracker capture program stage?

We have tried this:

/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc

and other versions like /api/26/events.json?orgUnit=YuQRtpLP10I&ouMode=CHILDREN but we get the result below. Your feedback is highly appreciated!

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Knut Staring

Department of Information, Evidence and Research

World Health Organization, Geneva, Switzerland

Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522

Skype: knutstar


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Abyot A. Gizaw.

Senior Engineer, DHIS2

University of Oslo

http://www.dhis2.org

I see. I am actually seeing a restriction when trying the example at the bottom of the page in the manual:

https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events

https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc&trackedEntityInstance=gfVxE3ALA9m&startDate=2014-01-01&endDate=2014-12-31

{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User has no read access to program: ur1Edk5Oe2n]"}
This is of course not the response you are getting.
Knut


Virus-free. www.avg.com

image

···

On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi Knut,

I am using a super user account and we don’t have data shared among users. Maybe the problem is related to the fact that Tracker data does not get exported in any format from the Import/Export app either. Aggregate data does, but tracker or event data does not.

Georgi

From: Knut Staring [mailto:knutst@gmail.com]

Sent: Tuesday, February 6, 2018 3:42 PM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: DHIS 2 Developers list dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net; Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

Just a thought - is the user you are using for the API member of the user group for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,

Georgi

From: Georgi Chakarov

Sent: Monday, February 5, 2018 6:20 PM

To: ‘DHIS 2 Developers list’ dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net

Cc: Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Access Tracker capture program stage data through API

Hi all,

Can anyone tell me what is the query to read all data entered in a Tracker capture program stage?

We have tried this:

/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc

and other versions like /api/26/events.json?orgUnit=YuQRtpLP10I&ouMode=CHILDREN but we get the result below. Your feedback is highly appreciated!

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Knut Staring

Department of Information, Evidence and Research

World Health Organization, Geneva, Switzerland

Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522

Skype: knutstar

Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Yes, and I am trying to get all data for all tracked entity instances, not for a specific one. Any idea?

image

image

···

I see. I am actually seeing a restriction when trying the example at the bottom of the page in the manual:

https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events

https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc&trackedEntityInstance=gfVxE3ALA9m&startDate=2014-01-01&endDate=2014-12-31

{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User has no read access to program: ur1Edk5Oe2n]"}
This is of course not the response you are getting.
Knut

Virus-free.
www.avg.com

On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi Knut,

I am using a super user account and we don’t have data shared among users. Maybe the problem is related to the fact that Tracker data does not get exported in any format from the Import/Export app either. Aggregate data does, but tracker or event data does not.

Georgi

From: Knut Staring [mailto:knutst@gmail.com]

Sent: Tuesday, February 6, 2018 3:42 PM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: DHIS 2 Developers list dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net; Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

Just a thought - is the user you are using for the API member of the user group for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,

Georgi

From: Georgi Chakarov

Sent: Monday, February 5, 2018 6:20 PM

To: ‘DHIS 2 Developers list’ dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net

Cc: Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net

Subject: Access Tracker capture program stage data through API

Hi all,

Can anyone tell me what is the query to read all data entered in a Tracker capture program stage?

We have tried this:

/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc

and other versions like /api/26/events.json?orgUnit=YuQRtpLP10I&ouMode=CHILDREN but we get the result below. Your feedback is highly appreciated!

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation,
720 Bathurst Street, Toronto Canada M5S 2R4
| *You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Knut Staring

Department of Information, Evidence and Research

World Health Organization, Geneva, Switzerland

Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522

Skype: knutstar

Knut Staring

Department of Information, Evidence and Research

World Health Organization, Geneva, Switzerland

Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522

Skype: knutstar

That is because if the new sharing setting. You need to go and configure data read and write sharing settings…

The same url should work in 2.28 and lower versions.

image

image

image

···

Thank you,

Abyot

Hi Abyot,

I am probably just stupid, but why is it complaining about a different program (ur1Edk5Oe2n) than the one requested in the URL (eBAyeGv0exc) ?

And even after sharing both programs with the administrator group which admin is a member of, I still get the same?

Knut

May be complaining about program stage?

···

On Feb 6, 2018 17:21, “Knut Staring” knutst@gmail.com wrote:

Hi Abyot,

I am probably just stupid, but why is it complaining about a different program (ur1Edk5Oe2n) than the one requested in the URL (eBAyeGv0exc) ?

And even after sharing both programs with the administrator group which admin is a member of, I still get the same?

Knut

On Tue, Feb 6, 2018 at 5:00 PM, Abyot Asalefew Gizaw abyot@dhis2.org wrote:

That is because if the new sharing setting. You need to go and configure data read and write sharing settings…

The same url should work in 2.28 and lower versions.

On Tue, Feb 6, 2018, 16:55 Georgi Chakarov georgi@logicaloutcomes.net wrote:

Yes, and I am trying to get all data for all tracked entity instances, not for a specific one. Any idea?

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Tuesday, February 6, 2018 5:43 PM

To: Georgi Chakarov georgi@logicaloutcomes.net
Cc: DHIS 2 Developers list dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net; Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net
Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

I see. I am actually seeing a restriction when trying the example at the bottom of the page in the manual:

https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events

https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc&trackedEntityInstance=gfVxE3ALA9m&startDate=2014-01-01&endDate=2014-12-31

{“httpStatus”:“Conflict”,“httpStatusCode”:409,“status”:“ERROR”,“message”:"[User has no read access to program: ur1Edk5Oe2n]"}

This is of course not the response you are getting.

Knut

Virus-free. www.avg.com

On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi Knut,

I am using a super user account and we don’t have data shared among users. Maybe the problem is related to the fact that Tracker data does not get exported in any format from the Import/Export app either. Aggregate data does, but tracker or event data does not.

Georgi

From: Knut Staring [mailto:knutst@gmail.com]
Sent: Tuesday, February 6, 2018 3:42 PM
To: Georgi Chakarov georgi@logicaloutcomes.net
Cc: DHIS 2 Developers list dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net; Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net
Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

Just a thought - is the user you are using for the API member of the user group for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,

Georgi

From: Georgi Chakarov
Sent: Monday, February 5, 2018 6:20 PM
To: ‘DHIS 2 Developers list’ dhis2-devs@lists.launchpad.net; dhis2-users@lists.launchpad.net
Cc: Michal Debski michal.debski@logicaloutcomes.net; Wojtek Bak wojtek@logicaloutcomes.net
Subject: Access Tracker capture program stage data through API

Hi all,

Can anyone tell me what is the query to read all data entered in a Tracker capture program stage?

We have tried this:

/api/26/events.json?orgUnit=DiszpKrYNg8&program=eBAyeGv0exc

and other versions like /api/26/events.json?orgUnit=YuQRtpLP10I&ouMode=CHILDREN but we get the result below. Your feedback is highly appreciated!

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar

Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Thank you,
Abyot


Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar