
Announcements
Hello,
I'm stumped on an issue. Disclaimer: I know very little about JSON. Thanking anyone in advance that can help me figure out what I'm doing wrong.
Here's my flow:
This is the raw JSON data from the "Get JSON" step - with some of the results removed for security:
{
"statusCode": 200,
"headers": {
"Cache-Control": "no-store, must-revalidate, no-cache",
"Pragma": "no-cache",
"ETag": "removed",
"X-Robots-Tag": "none",
"X-Request-ID": "removed",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains;",
"X-XSS-Protection": "1; mode=block",
"X-Content-Type-Options": "nosniff",
"P3P": "CP=\"IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT\"",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Fri, 16 Feb 2024 16:52:44 GMT",
"Content-Length": 2097,
"Content-Type": "application/json; charset=UTF-8",
"Expires": "0"
},
"body": {
"formDataList": {
"completed": "2024-02-16 07:31:12",
"email": "TEST",
"role": "SIGNER",
"first": "Test",
"last": "",
"title": "",
"company": "",
"initials": "TT",
"AP Contact": "1",
"AP Email Address": "1",
"Account Numbers": "",
"Account Numbers_2": "",
"Address_3": "1",
"Address_4": "",
"Annual Sales": "1",
"Applicant Company Address": "",
"Applicant Company Name Company": "",
"Applicant Name": "1",
"Applicant Title": "1",
"ApplicantName": "",
"ApplicantTitle": "",
"Bankruptcy": "No",
"Billing Address": "removed",
"BillingCityStateZip": "removed",
"Business Type": "LLC",
"CityStateZip_3": "1",
"CityStateZip_4": "",
"CityStateZip_5": "",
"CityStateZip_6": "",
"CityStateZip_7": "",
"CompanyName": "TEST",
"Contact": "",
"Contact_2": "",
"DBA": "",
"Date_2": "",
"Date_3": "",
"Date_4": "",
"Date_5": "",
"Email": "",
"EmailRow1": "1",
"EmailRow1_2": "",
"EmailRow1_3": "",
"Email_2": "",
"Email_3": "",
"Email_4": "",
"EstDate": "",
"FEID": "1",
"Fax": "",
"Fax_10": "",
"Fax_11": "",
"Fax_12": "",
"Fax_13": "",
"Fax_2": "",
"Fax_3": "",
"Fax_4": "",
"Fax_5": "",
"Fax_6": "",
"Fax_7": "",
"Fax_8": "",
"Fax_9": "",
"Home Address": "",
"Home Address_2": "",
"Home Address_3": "",
"Limit Request": "$1",
"Name_10": "",
"Name_11": "",
"Name_12": "",
"Name_13": "",
"Name_14": "",
"Name_15": "",
"Name_16": "1",
"Name_4": "1",
"Name_5": "",
"Name_6": "",
"Name_7": "",
"Name_8": "1",
"Name_9": "1",
"Owner2Address": "",
"Owner2Name": "",
"Owner2Ownership": "",
"Owner2Title": "",
"OwnerAddress": "1",
"OwnerName": "1",
"OwnerTitle": "1",
"Ownership": "1",
"Phone": "",
"Phone_10": "",
"Phone_11": "",
"Phone_12": "",
"Phone_2": "1",
"Phone_3": "",
"Phone_4": "",
"Phone_5": "",
"Phone_6": "",
"Phone_7": "",
"Phone_8": "1",
"Phone_9": "1",
"Primary Bank": "1",
"Purchase_Auth": "",
"SSN": "",
"SSN_2": "",
"SSN_3": "",
"Salesrep": "Test Sales",
"Secondary Bank": "",
"ShipCityStateZip": "1",
"Shipping Address": "1",
"Signature 1": "",
"Signature 2": "",
"Signature 3": "",
"State of EstablishmentIncorporation": "1",
"Telephone": "1",
"Title_4": "1",
"Title_5": "",
"Title_6": "",
"Title_7": "",
"Title_8": "1",
"agreementId": "hidden for security",
"email verified": "2024-02-16 07:31:12",
"web form signed/approved": "2024-02-16 07:31:10"
}
For the Parse JSON step, I use the above data as the sample to generate the schema. This is the raw JSON output from that step:
{
"body": {
"formDataList": {
"completed": "2024-02-16 07:31:12",
"email": "TEST",
"role": "SIGNER",
"first": "Test",
"last": "",
"title": "",
"company": "",
"initials": "TT",
"AP Contact": "1",
"AP Email Address": "1",
"Account Numbers": "",
"Account Numbers_2": "",
"Address_3": "1",
"Address_4": "",
"Annual Sales": "1",
"Applicant Company Address": "",
"Applicant Company Name Company": "",
"Applicant Name": "1",
"Applicant Title": "1",
"ApplicantName": "",
"ApplicantTitle": "",
"Bankruptcy": "No",
"Billing Address": "TEST",
"BillingCityStateZip": "TEST",
"Business Type": "LLC",
"CityStateZip_3": "1",
"CityStateZip_4": "",
"CityStateZip_5": "",
"CityStateZip_6": "",
"CityStateZip_7": "",
"CompanyName": "TEST",
"Contact": "",
"Contact_2": "",
"DBA": "",
"Date_2": "",
"Date_3": "",
"Date_4": "",
"Date_5": "",
"Email": "",
"EmailRow1": "1",
"EmailRow1_2": "",
"EmailRow1_3": "",
"Email_2": "",
"Email_3": "",
"Email_4": "",
"EstDate": "",
"FEID": "1",
"Fax": "",
"Fax_10": "",
"Fax_11": "",
"Fax_12": "",
"Fax_13": "",
"Fax_2": "",
"Fax_3": "",
"Fax_4": "",
"Fax_5": "",
"Fax_6": "",
"Fax_7": "",
"Fax_8": "",
"Fax_9": "",
"Home Address": "",
"Home Address_2": "",
"Home Address_3": "",
"Limit Request": "$1",
"Name_10": "",
"Name_11": "",
"Name_12": "",
"Name_13": "",
"Name_14": "",
"Name_15": "",
"Name_16": "1",
"Name_4": "1",
"Name_5": "",
"Name_6": "",
"Name_7": "",
"Name_8": "1",
"Name_9": "1",
"Owner2Address": "",
"Owner2Name": "",
"Owner2Ownership": "",
"Owner2Title": "",
"OwnerAddress": "1",
"OwnerName": "1",
"OwnerTitle": "1",
"Ownership": "1",
"Phone": "",
"Phone_10": "",
"Phone_11": "",
"Phone_12": "",
"Phone_2": "1",
"Phone_3": "",
"Phone_4": "",
"Phone_5": "",
"Phone_6": "",
"Phone_7": "",
"Phone_8": "1",
"Phone_9": "1",
"Primary Bank": "1",
"Purchase_Auth": "",
"SSN": "",
"SSN_2": "",
"SSN_3": "",
"Salesrep": "TEST REP",
"Secondary Bank": "",
"ShipCityStateZip": "1",
"Shipping Address": "1",
"Signature 1": "",
"Signature 2": "",
"Signature 3": "",
"State of EstablishmentIncorporation": "1",
"Telephone": "1",
"Title_4": "1",
"Title_5": "",
"Title_6": "",
"Title_7": "",
"Title_8": "1",
"agreementId": "removed",
"email verified": "2024-02-16 07:31:12",
"web form signed/approved": "2024-02-16 07:31:10"
The parsed data does convert to dynamic content fields here:
I then use these dynamic fields in my last step:
But the content is returning no data. This is the raw input on the last step:
I feel like perhaps my schema is wrong, but I have no clue. Here's the schema:
{
"type": "object",
"properties": {
"statusCode": {
"type": "string"
},
"headers": {
"type": "object",
"properties": {
"Cache-Control": {
"type": "string"
},
"Pragma": {
"type": "string"
},
"ETag": {
"type": "string"
},
"X-Robots-Tag": {
"type": "string"
},
"X-Request-ID": {
"type": "string"
},
"Strict-Transport-Security": {
"type": "string"
},
"X-XSS-Protection": {
"type": "string"
},
"X-Content-Type-Options": {
"type": "string"
},
"P3P": {
"type": "string"
},
"Timing-Allow-Origin": {
"type": "string"
},
"x-ms-apihub-cached-response": {
"type": "string"
},
"x-ms-apihub-obo": {
"type": "string"
},
"Date": {
"type": "string"
},
"Content-Length": {
"type": "integer"
},
"Content-Type": {
"type": "string"
},
"Expires": {
"type": "string"
}
}
},
"body": {
"type": "object",
"properties": {
"formDataList": {
"type": "object",
"properties": {
"completed": {
"type": "string"
},
"email": {
"type": "string"
},
"role": {
"type": "string"
},
"first": {
"type": "string"
},
"last": {
"type": "string"
},
"title": {
"type": "string"
},
"company": {
"type": "string"
},
"initials": {
"type": "string"
},
"AP Contact": {
"type": "string"
},
"AP Email Address": {
"type": "string"
},
"Account Numbers": {
"type": "string"
},
"Account Numbers_2": {
"type": "string"
},
"Address_3": {
"type": "string"
},
"Address_4": {
"type": "string"
},
"Annual Sales": {
"type": "string"
},
"Applicant Company Address": {
"type": "string"
},
"Applicant Company Name Company": {
"type": "string"
},
"Applicant Name": {
"type": "string"
},
"Applicant Title": {
"type": "string"
},
"ApplicantName": {
"type": "string"
},
"ApplicantTitle": {
"type": "string"
},
"Bankruptcy": {
"type": "string"
},
"Billing Address": {
"type": "string"
},
"BillingCityStateZip": {
"type": "string"
},
"Business Type": {
"type": "string"
},
"CityStateZip_3": {
"type": "string"
},
"CityStateZip_4": {
"type": "string"
},
"CityStateZip_5": {
"type": "string"
},
"CityStateZip_6": {
"type": "string"
},
"CityStateZip_7": {
"type": "string"
},
"CompanyName": {
"type": "string"
},
"Contact": {
"type": "string"
},
"Contact_2": {
"type": "string"
},
"DBA": {
"type": "string"
},
"Date_2": {
"type": "string"
},
"Date_3": {
"type": "string"
},
"Date_4": {
"type": "string"
},
"Date_5": {
"type": "string"
},
"Email": {
"type": "string"
},
"EmailRow1": {
"type": "string"
},
"EmailRow1_2": {
"type": "string"
},
"EmailRow1_3": {
"type": "string"
},
"Email_2": {
"type": "string"
},
"Email_3": {
"type": "string"
},
"Email_4": {
"type": "string"
},
"EstDate": {
"type": "string"
},
"FEID": {
"type": "string"
},
"Fax": {
"type": "string"
},
"Fax_10": {
"type": "string"
},
"Fax_11": {
"type": "string"
},
"Fax_12": {
"type": "string"
},
"Fax_13": {
"type": "string"
},
"Fax_2": {
"type": "string"
},
"Fax_3": {
"type": "string"
},
"Fax_4": {
"type": "string"
},
"Fax_5": {
"type": "string"
},
"Fax_6": {
"type": "string"
},
"Fax_7": {
"type": "string"
},
"Fax_8": {
"type": "string"
},
"Fax_9": {
"type": "string"
},
"Home Address": {
"type": "string"
},
"Home Address_2": {
"type": "string"
},
"Home Address_3": {
"type": "string"
},
"Limit Request": {
"type": "string"
},
"Name_10": {
"type": "string"
},
"Name_11": {
"type": "string"
},
"Name_12": {
"type": "string"
},
"Name_13": {
"type": "string"
},
"Name_14": {
"type": "string"
},
"Name_15": {
"type": "string"
},
"Name_16": {
"type": "string"
},
"Name_4": {
"type": "string"
},
"Name_5": {
"type": "string"
},
"Name_6": {
"type": "string"
},
"Name_7": {
"type": "string"
},
"Name_8": {
"type": "string"
},
"Name_9": {
"type": "string"
},
"Owner2Address": {
"type": "string"
},
"Owner2Name": {
"type": "string"
},
"Owner2Ownership": {
"type": "string"
},
"Owner2Title": {
"type": "string"
},
"OwnerAddress": {
"type": "string"
},
"OwnerName": {
"type": [
"string",
"null"
]
},
"OwnerTitle": {
"type": "string"
},
"Ownership": {
"type": "string"
},
"Phone": {
"type": "string"
},
"Phone_10": {
"type": "string"
},
"Phone_11": {
"type": "string"
},
"Phone_12": {
"type": "string"
},
"Phone_2": {
"type": "string"
},
"Phone_3": {
"type": "string"
},
"Phone_4": {
"type": "string"
},
"Phone_5": {
"type": "string"
},
"Phone_6": {
"type": "string"
},
"Phone_7": {
"type": "string"
},
"Phone_8": {
"type": "string"
},
"Phone_9": {
"type": "string"
},
"Primary Bank": {
"type": "string"
},
"Purchase_Auth": {
"type": "string"
},
"SSN": {
"type": "string"
},
"SSN_2": {
"type": "string"
},
"SSN_3": {
"type": "string"
},
"Salesrep": {
"type": "string"
},
"Secondary Bank": {
"type": "string"
},
"ShipCityStateZip": {
"type": "string"
},
"Shipping Address": {
"type": "string"
},
"Signature 1": {
"type": "string"
},
"Signature 2": {
"type": "string"
},
"Signature 3": {
"type": "string"
},
"State of EstablishmentIncorporation": {
"type": "string"
},
"Telephone": {
"type": "string"
},
"Title_4": {
"type": "string"
},
"Title_5": {
"type": "string"
},
"Title_6": {
"type": "string"
},
"Title_7": {
"type": "string"
},
"Title_8": {
"type": "string"
},
"agreementId": {
"type": "string"
},
"email verified": {
"type": "string"
},
"web form signed/approved": {
"type": "string"
}
}
}
}
}
}
}
Thanks in advance to anyone who can help.
Solved.
I was using the "raw output" data to auto generate the schema and that was the problem. When I used the "form data" to create the schedule (just the body and no headers) it worked.