search

OpenFn / grassroot-soccer

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

Add new mapping to upsertRiskVulnerabilityNewReferrals job #37

Closed daissatou2 closed 2 years ago

daissatou2 commented 2 years ago

Background and specific request

As discussed, insert new mapping in the upsertRiskVulnerabilityNewReferrals job.

Commcare source value: state.data.form.client_information.intervention_name SF Destination field: Event__c on the Newreferrals__c object

This field should be configured as a relationship where the lookup field is the CommCare_Case_ID__c.

Transformation: There are two versions of this form. One that has state.data.form.client_information.intervention_name in state and one that doesn't. The job should be able to handle both. If the intervention_name is missing from state, the job should not upsert this field.

I have added all of this information to the mappings.

state.json

{ "configuration": "GRS Salesforce Production", "data": "Data linked above" }

expression.js

upsertRiskVulnerabilityNewReferrals

output.json

Running against this state should result in a successful run where Event__c is not inserted. Running against this state should result in a successful run where Event__c is inserted.

lakhassane commented 2 years ago

@daissatou2 corrections done here:

For when there is no intervention_name: https://www.openfn.org/projects/grs-integrations/runs/0620a337-d12c-7429-92ba-47c4f9279f6e

For when there is intervention_name: https://www.openfn.org/projects/grs-integrations/runs/0620a33a-3e7b-74e2-bea4-778b9c463777 For that one there is an error you need to check because the intervention_name value does not exist in salesforce