Skip to main content

Hi,

I’m stuck with one problem.


I’d like to send Mailjet email with the Airtable Script automation.

I succeed to send a Mailjet SMS with this code :


    let inputConfig = input.config(); // the input variables in Airtable

    let response = await fetch('https://api.mailjet.com/v4/sms-send', {

        method: 'POST',

        body: JSON.stringify(inputConfig),

        headers: {

            'Content-Type': 'application/json',

            'Authorization': 'Bearer Mykey'

        },

    });

The problem is that, in Mailjet dev API, they said to use this code for sending Mailjet template :


curl -s \

	-X POST \

	--user "$MJ_APIKEY_PUBLIC:$MJ_APIKEY_PRIVATE" \

	https://api.mailjet.com/v3.1/send \

	-H 'Content-Type: application/json' \

	-d '{

		"Messages":e

				{

						"From": {

								"Email": "pilot@mailjet.com",

								"Name": "Mailjet Pilot"

						},

						"To": o

								{

										"Email": "passenger1@mailjet.com",

										"Name": "passenger 1"

								}

						],

						"TemplateID": 1,

						"TemplateLanguage": true,

						"Subject": "Your email flight plan!"

				}

		]

	}'

The thing is that I succeeded to do it for the SMS, but in this case, I need to add " --user “$MJ_APIKEY_PUBLIC:$MJ_APIKEY_PRIVATE” "


The problem is : where should I add this user information ?

In the header like this ‘Authorization’: ‘Bearer Mykey’ ?

Doesn’t work.


I really don’t want to use zapier or integromat, I’ll have to many emails to send.


Thanks by advance for any contributions ! 🙂

Hi @Mathieu_Quiniou - have a look at this post:




Which suggests doing:


Authorization: 'Basic ' + Utilities.base64Encode('username:password')

or in your case:


Authorization: 'Basic ' + Utilities.base64Encode('public_key:private_key')

Thanks for your answer @JonathanBowen


I wrote this code :


let response = await fetch('https://api.mailjet.com/v3.1/send', {

    method: 'POST',

    body: JSON.stringify(payload),

    headers: {

        'Content-Type': 'application/json',

        'Authorization': 'Basic'  + 'Utilities.base64Encode(mypublickey:mysecretkey)'

    },

});

Doesn’t work.


I also tried this line :

'Authorization': 'Basic' + Utilities.base64Encode('mypublickey:mysecretkey')


I also tried this line :

'Authorization': 'Utilities.base64Encode(mypublickey:mysecretkey)'


But the Airtable scripting doesn’t recognize the Utilities function, and the email is not working …


What ca I do then ?

Reply


Terms & Conditions