User activity logs are not getting captured properly for few cases

[Sachinbisht27]

Describe the bug We found that the activity logs for some of the users are not getting stored in the database because of the 2 cases diagnosed in the issue below. We wanted do the fixes for this issue.

Diagnosis:

• https://github.com/DostEducation/whatsapp-webhook-analytics/issues/64

Expected behavior

• [x] Create a new user flow log if the flow status is marked as 'completed' but no corresponding latest user flow log is found in the database. - 2-hour
• [x] Fix the logic to handle the activity_started value as 'no'. - 2-hour
• [x] Create a list of the Glific flows with webhooks not having a flow_status argument. - 1-hour
• [x] Update the Glific flows. - 1-hour
• [x] Test and deploy the fix in staging and production - 2-hour

Screenshots

Environment (please complete the following information):

• Sample Webhook Payload:

  {
  "activity_3_started": "no",
  "contact": {
      "id": 2211436,
      "name": "test user",
      "fields": {
          "activity_1_started": {
              "inserted_at": "2024-06-22T06:27:46.575939Z",
              "label": "activity_1_started",
              "type": "string",
              "value": "yes"
          },
          "activity_1_success": {
              "inserted_at": "2024-06-22T06:39:18.965786Z",
              "label": "activity_1_success",
              "type": "string",
              "value": "yes"
          },
          "activity_2_started": {
              "inserted_at": "2024-06-24T06:38:12.020941Z",
              "label": "activity_2_started",
              "type": "string",
              "value": "yes"
          },
          "activity_2_success": {
              "inserted_at": "2024-06-24T06:44:08.623844Z",
              "label": "activity_2_success",
              "type": "string",
              "value": "yes"
          },
          "activity_3_started": {
              "label": "activity_3_started",
              "type": "string",
              "value": "no",
              "inserted_at": "2024-06-27T00:32:00.836166Z"
          },
          "dost_content_completed": {
              "label": "dost_content_completed",
              "type": "string",
              "value": "activity_3_sent",
              "inserted_at": "2024-06-27T00:32:00.851027Z"
          },
          "group_name": {
              "inserted_at": "2024-06-22T13:15:01.955704Z",
              "label": "group_name",
              "type": "string",
              "value": "group_2"
          },
          "program_name": {
              "inserted_at": "2024-06-22T06:27:09.845249Z",
              "label": "program_name",
              "type": "string",
              "value": "bol_saathi"
          },
          "sign_up": {
              "inserted_at": "2024-06-22T06:27:09.835891Z",
              "label": "sign_up",
              "type": "string",
              "value": "yes"
          }
      },
      "phone": "919999999999"
  },
  "flow_id": "16963",
  "flow_name": "bs_iteration_3_activity_3",
  "flow_status": "completed",
  "flow_type": "activity",
  "flow_uuid": "27bfda00-1993-4258-a6f9-3a06d9889466",
  "organization_id": 11
  }

  • Environment - Production/Staging

Additional context NA

Acceptance Criteria

• [x] All the activity logs should be captured in the database properly

Documentation Add whatever documentation will be required here.

[Sachinbisht27]

Closing as completed and released in production.