Jun 01, 2022 04:09 AM
Hi, Professionals here,
I encounter a problem, I want to use EmailJS service to send HTML emails.
I try the automation of Airtable, the actions of “finding records” and “sending email”, but it is not as intelligent as I want, So I want to use EmailJS service.
So I wrote the below code in Airtable script.
let params = {
service_id:'service_gbwx81a',
template_id:'template_6euwe2d',
user_id:'cxkTio1YLQSY241rj',
template_params:{
to_name:"Stone",
from_name:"Stone",
reply_to:"Stone",
message: "ABC",
}
}
let headers = {
"Content-Type": "application/json",
};
let options = {
method: 'POST',
headers: headers,
body:JSON.stringify(params),
};
console.log(JSON.stringify(params));
let emailJSURL = 'https://api.emailjs.com/api/v1.0/email/send';
await doRemoteFetch(emailJSURL, "POST", params);
async function doRemoteFetch(url, postOrGet, body = null) {
let success = false
let fetchedData = null
let fetchOptions = {
method: postOrGet,
headers: {
"Content-Type": "application/json",
},
}
if (body) {
fetchOptions.body = JSON.stringify(body)
}
await remoteFetchAsync(url, fetchOptions)
.then((resp) => resp.json())
.then(function (data) {
output.inspect(data);
success = true
fetchedData = data
})
.catch(function (e) {
output.markdown("ERROR!");
output.markdown(e.message);
})
return {success: success, data: fetchedData}
}
But there is an error reported:
Unexpected token A in JSON at position 0
I checked the log in EmailJS account, no errors history there.
Can anyone help me to solve this problem?
Thanks a lot :slightly_smiling_face:
Solved! Go to Solution.
Jun 01, 2022 06:54 AM
Jun 01, 2022 06:54 AM
You are stringifying body
twice.
Jun 02, 2022 08:15 PM
Hi Bill, many thanks for your support.
The problem solved. :blush: