search

OpenFn / grassroot-soccer

Grassroot Soccer CommCare-Salesforce integrations
https://openfn.github.io/grassroot-soccer/
0 stars 0 forks source link

Bulk Get CommCare Forms Job not retrieving messages for `Register Skillz Plus Club` form #27

Closed daissatou2 closed 3 years ago

daissatou2 commented 3 years ago

Describe the bug

The Get CommCare Forms Bulk job does not post any new messages to the inbox when we run it with only the Register Skillz Plus Club xmlns uncommented. We know that there is data in CommCare for this form so running the job should post messages to the inbox.

CommCare data for this form

Previous messages which were automatically forwarded to OpenFn for this form

To Reproduce

  1. Here is a link to a failed run on OpenFn.org wihch is indicative of the bug: https://www.openfn.org/projects/pd3yk4/runs/r89794yr

expression.js

Link to the job itself in Github: https://github.com/OpenFn/grassroot-soccer/blob/master/jobs/1.getForms.js

state.json

NA

Expected behavior

We know that there is data in CommCare for this form so running the job should post messages to the inbox.

To test/resolve

  1. After the desired output is working locally (from the CLI), please [push commits to master || open a pull request].
  2. [Please test the change on OpenFn.org by re-running this run (https://www.openfn.org/projects/pd3yk4/runs/r89794yr) and confirming success.]
lakhassane commented 3 years ago

@daissatou2 this form proly exists, however I think we are not reaching it. When querying the list of forms in postman I see a total of 6565 form but the query by default only limits to 1000 reason why we can't see the Register Skillz Plus Club (I guess). To get the whol list of form we need to use this next key until it's over.

Screen Shot 2021-08-12 at 10 12 36

Do you have a link to the commcare api or at least access to the grassrootsoccer project in the HQ. I don't have the token then can't access to check the API if we can remove the limit

daissatou2 commented 3 years ago

Is this 6565 for all the forms or only for Register Skillz Plus Club submissions?

I commented out all the other forms in the job so we only grab the responses for the one form. We also tried limiting the responses to the dates when we know there were only a handful of submissions and still didn't receive any response. For example, we know there was a submission on May 5th, 2021 (https://www.openfn.org/projects/pd3yk4/messages/m784bkj4). So you can even limit the dates between May 4th and May 6th.

The account is GRS CommCare App in LP.

lakhassane commented 3 years ago

@daissatou2 I pushed the changes as discussed