[BACKFILLING] Incorrect content ID configured in rapidpro webhooks

[prtkdost]

Describe the bug In weekly monitoring, we found for 17 flows in rapid, content IDs are incorrectly configured in the webhook due to a human error.

Below are the - Flow Names - Incorrect Configured Content ID - Correct content ID

FINAL-DOST-Pilot-P1M15D1 | 326 | 332 FINAL-DOST-Pilot-P1M15D2 | 327 | 333 FINAL-DOST-Pilot-P1M15D3 | 328 | 334 FINAL-DOST-Pilot-P1M15D4 | 329 | 335 FINAL-DOST-Pilot-P1M15D5 | 330 | 336 FINAL-DOST-Pilot-P1M15D6 | 331 | 337 FINAL-DOST-Pilot-P1M15D7 | 332 | 338 FINAL-DOST-Pilot-P1M16D1 | 333 | 339 FINAL-DOST-Pilot-P1M16D2 | 334 | 340 FINAL-DOST-Pilot-P1M16D3 | 335 | 341 FINAL-DOST-Pilot-P1M16D4 | 336 | 342 FINAL-DOST-Pilot-P2M14D1 | 337 | 326 FINAL-DOST-Pilot-P2M14D2 | 338 | 327 FINAL-DOST-Pilot-P2M14D3 | 339 | 328 FINAL-DOST-Pilot-P2M14D4 | 340 | 329 FINAL-DOST-Pilot-P2M14D5 | 341 | 330 FINAL-DOST-Pilot-P2M14D6 | 342 | 331

This also must have led to the incorrect population of call-logs.

Expected behavior

• [ ] Fix webhooks @prtkdost
• [ ] Create query for backfilling
• [ ] Backfill the data and make sure the updated data is Migrated to Bigquery

There are more such cases, need to update this on some content ids in RapidPro as well https://docs.google.com/spreadsheets/d/1z12olEAfJ_Yb7UV8ZiB3AUvC3NbofA6wLIgCadHpAwg/edit#gid=0

[Satendra-SR]

For data correction, we need to fix the following table data:

• [ ] call_log
• [ ] ivr_prompt
• [ ] ivr_prompt_response
• [ ] module_content (may need to update the mapping)
• [ ] program_sequence (may need to update the mapping)

Note:

Check and confirm if the data has been updated to the BigQuery (after fixing in the application database).

[Satendra-SR]

• [ ] For P2M14, Check 375 created dates, update the data for relevant tables before this date.

[GauravGusain98]

@Satendra-SR @prtkdost This issue should also contain the list of onbarding calls fro which we need to update the content id. Sharing the flows list here

INTRO_1-SIGNUP_2-ONBOARDING, INTRO_1-SIGNUP_3-ONBOARDING, MODULE1_1-SIGNUP_1-SELECTION

Please check if there are any other intro flow except these 3.

[GauravGusain98]

@Satendra-SR We need to also validate if we are still facing this issue. If yes then we need to track that issue separately.