Uploading multiple files in attachment field by api requests

App Development
1

I am using python script to upload large amount of records. But can’t figure out how to upload multiple files in attachments field at once. I have tried to add multiple files in using API end point but it does not work. It only uploads last file
files=[
(‘field_54’,(‘image1.jpg’,open(‘another.jpg’,‘rb’),‘image/jpeg’)),
(‘field_54’,(‘image2.jpg’,open(‘iamge.jpg’,‘rb’),‘image/jpeg’))
]

Can any one have idea how to upload multiple file through API end point “Tadabase API”

2

Hi,

I was testing this in Webhooks recently and was advised it isn’t supported yet with the new Attachments field. I was just looking to chase it up actually ::smiley:

Thanks

Dan

3

Hi All,

Any Update on this functionality?

Thanks

Dan

4

I’m having the same issue :confused: Have you found any workarounds?

5

Looking for this as well.

6

@abridges @Dan I found a workaround doing this:

I’m using 2 tables:

Parent Table: Apartments
Child Table: Photos

  1. Inside a TadaBase, I use a Form component to create a new record in the Parent Table (Apartments), and trigger an API call to get the image files when the form is submitted.

  2. I send a parameter in the API call that includes the Record ID that I just created in the Parent Table.

  3. When the API responds, it triggers a Webhook that I created and is watching records on Make.com.

  4. Iterate the photos on Make

  5. Create one photo per record in the Child Table (Photos), and assign it to the Parent Table using the Record ID parameter I sent on step 2.

Does that make sense?

7

Hi Rez,

It does, and will do the job but will become cumbersome with multiple attachment fields and/or tables over time so I hope the team update the Tadabase Framework for the new Attachments Field so it can replace the old one fully.

Thanks

Dan

1 Like
8

Hi Tadabase,

Any update on this with the Webhooks and th new Attachment field?

Thanks

Dan

9

I found a workaround, since it accepts multiple files, you should put indexes. Here’s an example:

field_1[0]
field_1[1]
field_1[2]

it will update field_1 with 3 files

10

Hi All,

Are we any nearer to having simple single solution to integrate ZOHO Forms and Tadabase without needing to still depend on Zapier/Make/etc. to deal with it.

The request is a simple one, in ZOHO, when you submit a form, it has 3 Webhook types as detailed here: https://help.zoho.com/portal/en/kb/forms/integrations/webhooks/articles/response-format-for-content-type

On a form you can have data, subform data & attachments.

The “application/json” allows to send Data & Subform Data but not attachments, BUT if you setup another Integration to send the attachments to OneDrive for example, then the Webhook gives the Data & Subform Data and the URL to the attachments, giving all 3 pieces of information.

The application/x-www-form-encoded only allows sending the Data (No Subform Data or Attachments).

The “multipart/form-data” can send Data & Attachments, but not Sub Form Data.

So the only option to handle all 3 is the first one with json and using another storage integration.

This then sends the Data, Subform Data & URL’s for the attachments pointing to the storage service through the webhook.

But currently it then fails with “Can’t open file from url ######”

It didnt before so I assume it is an upgrade on authentication that I am missing now (Might be resolved with a custom connection: https://help.zoho.com/portal/en/kb/forms/adminguide/articles/connections-control-panel#Creating_a_Service).

And then after this if resolved, previously it would then just put the links into Tadabase pointng to the file(s) on the storage service, not transfer a copy to Tadabases storage.

The ideal would be just to transfer all 3 data types and not need the other storage service, I will also push ZOHO on this.

Thanks

Dan