How to bypass the error "Validation failed for 1 parameter(s). Missing value of required parameter 'url'."

Hello,
I am unable to handle an error in my scenario, I am collecting data through a tally form in the collected data there is the option to add 3 attachments or these attachments are optional so when an attachment is missing the module “create database item” does not execute, I would like to set up a rule which uses the URL of the attachment if it is available and which would ignore it if it is absent.
I don’t want to ignore the module but only use the URL data if it is not present.

I tried using “generales functions” but without success: {{ifempty(3.fields.Attachment #3 .url)}}{{(ignore)}}

Hi,
The most straightforward solution is to use a Router after your Tally trigger. The two routes with the same steps:

  1. If attachment exists (the current steps you have)
  2. If attachment doesn’t exist (the current steps you have, and do not map any File in the Notion module)
2 Likes

thank you for the solution but if I do that I end up with 11 outputs on my router, right? The Tally form contains 3 attachments and so I have to anticipate all cases, for example attachment n°1 is missing and n°2 and n°3 are present, case 2 n°1 and n°2 are absent and n°3 is present…

I understand and I agree this can become clunky (see below the line for a different approach). If you follow this approach, you would need 4 Routes as far as I can tell (and some if statements): one for when there is no file; one for when there is 1 file; one for when there are two files; one for where there are three files.

On each route, you can filter with this logic:

  1. {{attachment 1}} does not exist & {{attachment 2}} does not exist & {{attachment 3}} does not exist

  2. {{attachment 1}} EXISTS & {{attachment 2}} does not exist & {{attachment 3}} does not exist OR {{attachment 1}} does not exist & {{attachment 2}} EXISTS & {{attachment 3}} does not exist OR {{attachment 1}} does not exist & {{attachment 2}} does not exist & {{attachment 3}} EXISTS

→ then you can use if statements in the File Notion property to map the one attachment that EXISTS

  1. {{attachment 1}} EXISTS & {{attachment 2}} EXISTS & {{attachment 3}} does not exist OR {{attachment 1}} does not exist & {{attachment 2}} EXISTS & {{attachment 3}} EXISTS OR {{attachment 1}} EXISTS & {{attachment 2}} does not exist & {{attachment 3}} EXISTS

→ then you can use if statements in the File Notion property to map the one attachment that EXISTS

  1. {{attachment 1}} EXISTS & {{attachment 2}} EXISTS & {{attachment 3}} EXISTS

APPROACH 2 → Create only 1 File Upload field in Tally (and allow multiple files upload–you can also set a limit of 3 files). Use JSON Aggregation to upload one or multiple files at once in Notion.

In this case, create two routes:

  1. If no file exists → all the steps you have, and do not map any files in your Notion module

  2. If one or multiple files exist
    You can try to use this workflow: Loom | Free Screen & Video Recording Software | Loom

3 Likes

Thank you very much for the quality of your answer.

I tested the first approach but I’m stuck on the part of using if statements, I’m having trouble generating the functions with all the conditions provided.

On the other hand I was able to set up my scenario with approach 2, I had to do some workarounds to recover data other than attachments and the case where no attachment was transmitted, but it works.

If you ever have a little more content on the management of general functions within the framework of approach 1, I am interested, I would like to succeed in the 2 approaches but otherwise I thank you once again because thanks to your help my scenario is operational