We will need to update the Miller campaigns for Onder and Goldwater
{ "Lead ID": @{outputs('EmailRows')[0]}, "CaseType": @{variables('casetype')}, "Datereceived": @{formatDateTime(variables('retainDate'),'MM-dd-yyyy')}, "MarketingSource": @{variables('marketingsource')}, "Lead First Name": @{outputs('EmailRows')[1]}, "Lead Last Name": @{outputs('EmailRows')[2]}, "CellPhone": @{outputs('EmailRows')[3]}, "Address1": @{outputs('EmailRows')[4]}, "City": @{outputs('EmailRows')[5]}, "State": @{outputs('EmailRows')[6]}, "Zip": @{outputs('EmailRows')[7]}, "date of birth": @{outputs('EmailRows')[8]}, "email": @{outputs('EmailRows')[9]}, "072.124.001 - Are you currently represented by an attorney for this matter?": @{outputs('EmailRows')[10]}, "072.124.002 - What is the name of the affected party?": @{outputs('EmailRows')[11]}, "072.124.003 - Were you placed in a Juvenile Hall in Los Angeles County, CA? (MUST BE YES)": @{outputs('EmailRows')[12]}, "072.124.004 - Were you sexually abused by Staff member or other inmate?": @{outputs('EmailRows')[13]}, "072.124.005 - Did the abuse occur under the age of 18?": @{outputs('EmailRows')[14]}, "072.124.006 - What was the name of the facility that you attended?": @{outputs('EmailRows')[15]}, "072.124.007 - Agent use: Did the abuse happen at one of the listed facilities?": @{outputs('EmailRows')[16]}, "072.124.008 - Your DOB?": @{outputs('EmailRows')[19]}, "072.124.013 - When did the abuse occur?": @{outputs('EmailRows')[18]}, "072.124.012 - How long did you attend?": @{outputs('EmailRows')[25]}, "072.124.009 - What is the name of the abuser?": @{outputs('EmailRows')[26]}, "072.124.010 - Can you describe the abuser?": @{outputs('EmailRows')[21]}, "072.124.011 - If shown a picture of your abuser would you be able to identify them?": @{outputs('EmailRows')[22]}, "072.124.014 - Have you told anyone about the abuse?": @{outputs('EmailRows')[23]}, "072.124.038 - How many abusers were there?": @{outputs('EmailRows')[24]}, "072.124.039 - Abuser 1 Sex": @{outputs('EmailRows')[25]}, "072.124.041 - Abuser 1 Age ": @{outputs('EmailRows')[26]}, "072.124.042 - Abuser 1 Race/Ethnicity": @{outputs('EmailRows')[27]}, "072.124.043 - Abuser 1 Height": @{outputs('EmailRows')[28]}, "072.124.044 - Abuser 1 Weight/Build": @{outputs('EmailRows')[29]}, "072.124.045 - Abuser 1 Hair": @{outputs('EmailRows')[30]}, "072.124.046 - Abuser 1 Eyes": @{outputs('EmailRows')[31]}, "072.124.047 - Abuser 1 Distinguishing Marks ": @{outputs('EmailRows')[32]}, "072.124.048 - Abuser 1 Other Notes": @{outputs('EmailRows')[33]}, "072.124.049 - What was the Abuser 1 role?": @{outputs('EmailRows')[34]}, "072.124.050 - Where did you normally encounter abuser 1?": @{outputs('EmailRows')[35]}, "072.124.051 - Any other information about your abuser you can share?": @{outputs('EmailRows')[36]}, "072.124.052 - Abuser 2 Sex": @{outputs('EmailRows')[37]}, "072.124.053 - Abuser 2 Age": @{outputs('EmailRows')[38]}, "072.124.054 - Abuser 2 Height": @{outputs('EmailRows')[39]}, "072.124.055 - Abuser 2 Race/Ethnicity": @{outputs('EmailRows')[40]}, "072.124.056 - Abuser 2 Hair": @{outputs('EmailRows')[41]}, "072.124.057 - Abuser 2 Weight/Build": @{outputs('EmailRows')[42]}, "072.124.058 - Abuser 2 Distinguishing Marks": @{outputs('EmailRows')[43]}, "072.124.059 - Abuser 2 Eyes": @{outputs('EmailRows')[44]}, "072.124.060 - What was the abuser 2's role at the facility?": @{outputs('EmailRows')[45]}, "072.124.061 - Abuser 2 Other Notes": @{outputs('EmailRows')[46]}, "072.124.062 - Abuser 3 Sex": @{outputs('EmailRows')[47]}, "072.124.063 - Abuser 3 Age": @{outputs('EmailRows')[48]}, "072.124.064 - Abuser 3 Race/Ethnicity": @{outputs('EmailRows')[49]}, "072.124.065 - Abuser 3 Height": @{outputs('EmailRows')[50]}, "072.124.066 - Abuser 3 Weight/Build": @{outputs('EmailRows')[51]}, "072.124.067 - Abuser 3 Hair": @{outputs('EmailRows')[52]}, "072.124.068 - Abuser 3 Distinguishing Marks": @{outputs('EmailRows')[53]}, "072.124.069 - Abuser 3 Eyes": @{outputs('EmailRows')[54]}, "072.124.070 - Abuser 3 Other Notes": @{outputs('EmailRows')[55]}, "072.124.071 - What was the abuser 3's role at the facility?": @{outputs('EmailRows')[56]}, "072.124.024 - How many incidents of abuse were there?": @{outputs('EmailRows')[57]}, "072.124.025 - Please explain, to the best of your ability, the events that occurred": @{outputs('EmailRows')[58]}, "072.124.028 - Did the abuser wear gloves?": @{outputs('EmailRows')[59]}, "072.124.027 - Was there skin-to-skin contact?": @{outputs('EmailRows')[60]}, "072.124.072 - Agent Use: What type of sexual abuse occurred:": @{outputs('EmailRows')[61]}, "072.124.015 - Have you received or have ongoing treatment due to the incident?": @{outputs('EmailRows')[62]}, "072.124.016 - What kind of treatment? (If applicable)": @{outputs('EmailRows')[63]}, "072.124.017 - Did you go by another alias while attending?": @{outputs('EmailRows')[64]}, "072.124.018 - What is the name of your biological mother?": @{outputs('EmailRows')[65]}, "072.124.019 - DOB of your biological mother?": @{outputs('EmailRows')[66]}, "072.124.020 - What is the name of your biological father?": @{outputs('EmailRows')[67]}, "072.124.021 - DOB for your biological father?": @{outputs('EmailRows')[68]}, "072.124.022 - What is the name of your CASA volunteer/ guardian ad litem?": @{outputs('EmailRows')[69]}, "072.124.023 - Are you a member of a Native American Tribe, and if so, which one?": @{outputs('EmailRows')[70]}, "072.124.032 - What is your mailing address?": @{outputs('EmailRows')[71]}, "072.124.029 - Do you have an alternate contact number? (ask for a relationship to the person)": @{outputs('EmailRows')[72]}, "072.124.030 - Is it ok for us to contact this person in the event we can not reach you? (confirm yes)": @{outputs('EmailRows')[73]}, "072.124.031 - Do you give us permission to reference your case to them so they know why we're trying to reach you?": @{outputs('EmailRows')[74]}, "072.124.033 - Is the PNC female?": @{outputs('EmailRows')[75]}, "072.124.035 - Was a report filed for the instances of abuse?": @{outputs('EmailRows')[76]}, "072.124.037 - Relationship to you :": @{outputs('EmailRows')[77]}, "072.124.026 - Approximate age of abuser at the time of incidents": @{outputs('EmailRows')[26]} }
...we need to make those changes for GCP
THanl y'all for fixing something I missed.
They are..., however, I had to change the array position for the three bold fields.
on my map i did for GCP they look to be in the same position
Yes but don't you need to refer to the customfield?
"072.124.008 - Your DOB?": "c-1562",
"072.124.012 - How long did you attend?": "c-1511",
"072.124.009 - What is the name of the abuser?": "c-1510",
double checking but i think we have both of those campaigns mapped correctly
just confirmed with Zek for miller goldwater