How to map attachments from webhook to notion?

How To
, , ,
1

Hi,

I’m send data from a form on my website to a webhook one make, works fine.
From this form I can add up to 3 files as attachments.

here is the current scenario :

1 : data received on webhook

2 : iterator to read every file attached on attachments + iterator output

file
file1890×1417 133 KB

3 : set variable for each file re-build correctly the URL + set variable output

file
file1890×1417 198 KB

4 : array agregator to build an array with all clean attachments URLs + array agregator output

file
file1890×1417 146 KB

5 : iterator to make a right array with file_url variable + iterator output

file
file1890×1417 151 KB

6 : insert database item on notion

10
101629×1431 291 KB

but I get this error :

11
11907×460 31.4 KB

Any idea?

Thanks
L

2

Hi,
That’s because a File property in Notion expects an array with name and url - see Page properties

So, if you want to map multiple files, you need to setup the correct array before mapping it like you show in the screenshot.
If you are sure you’re always adding only 1 file instead, you can turn off the “Map” toggle in the Make field, and add the name + url directly (mapped from previous modules or manual as needed)

3

ok thanks I see now.
But how to format correctly the array to match what notion expects?

4

I have tried to add a CREATE JSON module like this Imgur: The magic of the Internet
But the output looks like this:

[
    {
        "json": "{\"files\":[{\"file_url\":\"https://www.website.com/images/upload_support/cf_68036eac98191_anonymous-wallpaper.jpg\"}"
    }
]

How can I make it looks like this ?

{
  "files": [
    {
      "name": "cf_6805814f424ae_support.txt",
      "external": {
        "url": "https://www.website.com/images/upload_support/cf_6805814f424ae_support.txt"
      }
    }
  ]
}
5

You can create a data structure that matches the second JSON. In the JSON module, create a data structure from JSON, and copy-paste the JSON from the Notion documentation to generate the data structure

6

I did but the output provided by Create JSON module looks like this :

[
    {
        "json": "{\"files\":[{\"name\":\"cf_6806a4eb6733a_support.txt\",\"external\":{\"url\":\"https://www.website.com/images/upload_support/cf_6806a4eb6733a_support.txt\"}}]}"
    }
]
7

Or looks like this also :

[
    {
        "json": "{\"properties\":{\"Blueprint\":{\"files\":[{\"name\":\"cf_6806a4eb6733a_support.txt\",\"external\":{\"url\":\"https://www.website.com/images/upload_support/cf_6806a4eb6733a_support.txt\"}}]}}}"
    }
]
8

why the JSON output looks like this?

9

That looks like the raw JSON output - I would try using a “Parse JSON” module right after “Create JSON” to clean up the output, and then map the output of Parse JSON into the Notion module

1 Like
10

ok thank you I try this