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}}”
}
}
Hi @Kappa_Lambda_Omega_C ,
Welcome to the Make community. You might have used an incorrect URL. See the hint below the URL field:
Cheers,
Henk
I did update the url to “https://api.wildapricot.org/v2.2/accounts/accountID/invoices” and I still get the error. I’m not sure what I need to change.
Then it is still incorrect. Read the hint again, it should be:
/accounts/accountID/invoices
Enter a path relative to https://api.wildapricot.org/v2.2
Cheers,
Henk
I’ll give the url update a try. Thanks
I’m still getting the error. Is there anyway I can get some help on this issue?
@alex.newpath I believe this is in your lane.
1 Like
Sure. Can you share your scenario please? My company NewPath Consulting are WildApricot partners and have a lot of experience with their API.
Use the new share feature and share the link so I can have a Quick Look.
That’s not the scenario. Go to the scenario and look for the share link in the upper right corner in the scenario editor. Click share and then setup a link and place it here.
Hi there,
The payload you are using for the Create Invoice API call for WildApricot is incorrectly formatted. Here’s a link to a scenario with the Make API call with the following payload that works.
Here’s the working payload in JSON. You will want to replace the values that need to be mapped from your spreadsheet.
There are a few fields that are strictly optional and the details on the WildApricot API documentation will show you the “schema” that the call uses. It’s a relatively complex payload to get right because it can have a nested array for the OrderDetails key. There are also specific values that are usable for the OrderType and OrderDetailType key also documented in the API.
{
“DocumentNumber”: “999”,
“IsPaid”: false,
“PaidAmount”: 4248.01,
“OrderType”: “MembershipRenewal”,
“OrderDetails”: [
{
“Value”: 0.01,
“Qty”: 1,
“Notes”: “Membership renewal. Level: Hockey Player. Renew to November 18, 2024”,
“OrderDetailType”: “MemberLevel”,
“Taxes”: null
},
{
“Value”: 248.00,
“Qty”: 1,
“Notes”: “Extras: Membership Fee Based on Salary - $70,000+”,
“OrderDetailType”: “ExtraCost”,
“Taxes”: null
},
{
“Value”: 4000.00,
“Qty”: 1,
“Notes”: “Extras: Donation (new application and renewals only): 4,000 x $1.00 (CAD)”,
“OrderDetailType”: “ExtraCost”,
“Taxes”: null
}
],
“Memo”: “”,
“Value”: 4248.01,
“DocumentDate”: “2025-11-18T00:07:47+00:00”,
“Contact”: {
“Id”: 37415038
},
“CreatedDate”: “2025-11-18T00:07:47”
}
1 Like
Thank you I’ll give this scenario a try.
2 Likes
