I am working on a process flow that pulls information from an email that I get when someone enters thier information from my website. Below are my settings and I cannot seem to get it to post. Is there a field I am missing that needs populated? Any helpisgreatly appreciated!
Authentication: None
Request method: Post
URL:https://my-domain.com/api/v1/clients/create.php?api_key=supersecretAPI
JSON:
{
"name": "{{ $json.firstName }} {{ $json.lastName }}"
"website": "",
"referral": "Website Contact Form",
"rate": 0,
"currency_code": "USD",
"net_terms": ""
"tax_id_number": "",
"lead": 1,
"notes": "Submitted via contact form.\nSubject: {{ $json.subject }}\nMessage: {{ $json.message }}"
}
I am use N8N to run the process and the node runs but I get the below message. I cant seem to find anything else that needs to be defined.
[
{
"success": "False",
"message": "Auth success but insert query failed, ensure ALL required variables are provided (and aren't duplicates where applicable) and database schema is up-to-date. Turn on error logging and look for 'undefined index'."
}
]