Brevo connection: impossible to pass email value

:camera_with_flash: Screenshots: scenario setup, module configuration, errors

Your webhook is receiving a JSON object as a string. You need to parse it before feeding individual fields to Brevo module.

Thanks a lot. I’ll doit

Could you tell me how to do it, or where to find the information to do it? I’ve been trying for our to no results.

TIA

Charles

Copy the output from your webhook {"Pr\u00...136"}.
Add a Parse JSON module.
Click Data Structure → Add → Generate.
Paste the JSON string and create the expected data structure.
Map the webhook result to the JSON string field.
Run it with existing data from a previous run and check if parsing works.

If so, map each individual value to the Brevo module.
Else, troubleshoot.

@damato

Thank you for your help.

This is what I tried to do… create a Parse JSON module from my Brevo module, but didn’t work. I create ut from the Webhook…Should I delete my Brevo module, then create the Parse JSON module, and then recreate my Brevo module?

TIA

Charles

That’s not necessary. You can insert the parse json module between the webhook and Brevo. Just run it to check if the values are being correctly parsed and then map them to Brevo.

Maybe you can debate a few screenshots of how you’re trying to set up parse json.

Hi Damato,

I really appreciate your help. Here is what I can do. What I can’t do is insert the parse json module between the webhook and Brevo

TIA

Charles

Right-click the dotted ines and select Unlink.
Rearrange the modules in the correct order.
Click on “Add” on the Data structure field, then Generate. Paste the contents of the string that the webhook received. That should create the data structure. You can skip this step and let Make do the magic for you. It might work.
Then run the first 2 modules and map the values to Brevo.

Or post the setup and results of the webhook. Maybe it’ll be easier to help you with that info.

Thanks a million

Welcome to the Make community!

It appears that the data received by your webhook is invalid JSON? You might want to verify that the data received is valid first, otherwise you should contact the external service sending the data to your webhook URL.

You can verify whether a JSON is valid by copy-pasting it into jsonformatter.org

If it it valid JSON, by default the Webhook module should have automatically parsed the request body into variables.

Hope this helps! If you are still having trouble, please provide more details.

— @samliew

Indeed, but then you’re giving control of your outcome to the external tool. I’ll always prefer fixed structures over automatic configuration. If the provider changes the structure at any time, the parsing phase simply breaks, whereas an automatic parse can finish successfully and generate wrong results.

@damato

Please click the white bubble on the top right of the webhook module after it executes and show its results, specially the json part.

After reading your very useful comments and advice, I have started a new scenario. It’s better, thank you. Here is my new problem: my new API returns this 401 error. I’ve followed the doc to create the api. What I’m l doing wrong?

TIA

Charles

You’re not mapping any values from the Webhook module.

We’d love to help, however, we require more information that demonstrates the problem to help us reproduce the scenario and any issues and errors. To allow others to assist you, please provide the following:

A. Scenario Blueprint

Providing your scenario will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return. This would benefit you in implementing our suggestions as you can view screenshots of the changes or paste corrected modules back into your scenario.

Expand Instructions â—€

A. Export Blueprint

In the scenario editor, click the three dots at the top-right, then select “Export blueprint”.

  • You can upload files and images to this forum by clicking on the upload button:

    Uploading an attachment here will look like this:
    blueprint.json (12.3 KB)

B. Create Public Share Link

In the scenario editor, click on the Share button:

Read more about the scenario sharing feature in the Help Centre.

B. Properly-formatted Output Bundles from a Scenario Run

Please provide the Input / Output bundles of each of the relevant modules from the Scenario History, or by re-running the scenario.

Expand Instructions â—€

Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.

A. Upload a Text File

Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.

  • You can upload files and images to this forum by clicking on the upload button:

    Uploading an attachment here will look like this:
    module1-input.txt (1.2 KB), module1-output.txt (3.4 KB)

B. Insert a Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly with the “Preformatted Text” (code) button in the rich-text editor. Otherwise the forum software will change the content, making them invalid!

:warning: Formatting IS Important! :warning:

Here are some ways to provide text content in a way that it won’t be modified by the forum.

  • Method 1: Type code fence manually —
    Manually type three backticks ``` in a separate line before and after the content, like this,

    ```
    text goes here
    ```
    
  • Method 2: Highlight the pasted content, then click the preformatted text/code button —

  • Method 3: Upload your file elsewhere and share the public link —
    This method is only advised for large files exceeding the forum upload limit.

Providing the Input / Output bundles will allow others to replicate what is going on, especially if there are complex data structures (like nested arrays and collections) and data from external services. This helps us with answering your question with valid examples, like mapping raw variable names (instead of the label/display name).


Sharing these details will make it easier for others to assist you, so that you can get better answers, faster.

— @samliew