I am trying to create my scenario that records a payment to an invoice using Google Sheets and the Wild Apricot API. I cannot find and fix the error. I get the data error message below. I’ve also added screenshots and my json script. I can’t find the rogue “:”
DataError
Your request was invalid: A potentially dangerous Request.Path value was detected from the client (:).. “A potentially dangerous Request.Path value was detected from the client (:).”
Origin
Wild Apricot
{
“invoiceId”: “{{1.6}}”,
“contact”: {
“contactId”: “{{1.0}}”,
“firstName”: “{{1.1}}”,
“lastName”: “{{1.2}}”,
“preferredFullName”: “{{1.3}}”,
“email”: “{{1.4}}”
},
“invoiceDate”: “{{1.5}}”,
“origin”: “{{1.7}}”,
“originDetails”: “{{1.8}}”,
“ticketType”: null,
“invoiceOpenBalance”: “{{1.10}}”,
“currency”: “USD”,
“status”: “{{1.12}}”,
“payment”: {
“Online/Offline”: “{{1.13}}”,
“paymentDate”: “{{1.14}}”,
“settledPaymentTypes”: [
“{{1.15}}”
],
“paymentMethodId”: “{{1.16}}”
},
“notes”: {
“internalNotes”: “{{1.17}}”,
“commentsForPayer”: “{{1.18}}”
}
}
