How to send a file coming from Hubspot to a SugarCRM Lead using Zapier ?

Hey Manuel M ,

I was looking at your post https://community.zapier.com/code-webhooks-52/how-to-send-a-file-coming-from-hubspot-to-a-sugarcrm-lead-28197 which has a little more details and screenshots.

First of all, I will be frank, I do not know what the hydrate format is.

If I were you, I would try to go back to basics first.

Normally, when you upload a file in Sugar as an attachment, it is stored against a Note record. And you can either upload a file against an existing note, or create a temporary file, and then create the note and move the temp file against it.

If you can get either of those to work, then you can attempt to attach a file to a record.

Following the tmp file upload and then note approach:

1) To upload a file, postman is normally set as "form-data" and on the key "filename" it sends the file, like this:

2) Then create a note with the tmp file guid and the file name:

Then you would receive back the note id within the response, and you should be able to verify if it worked by opening the Note with the record id and downloading again the attachment.

If that does not work, it might well be a limitation of Zapier (or incompatibility as well), but you will be able to verify that, after attempting this linear approach that I can confirm works.

If that's the case, you might have to find an alternative with something that might be a little more "beefed up" than Zapier.

All the best,

Ciao!

Ciao Enrico,

yes, I already achieved file saving on Lead and Note via Postman and Curl. They work flawlessly. 

In Zapier I tried 2 things, as you can see: store the file in a File Field, store the file in an existing Note (attachment field). No success.

To be honest, I didn't try to Create the note passing also the file but I'm afraid that won't work, because the format it's the same.

Could be, as you say, a limitation of Zapier but ... I hope it isn't because we have already other flows created inside. 

"Normally, when you upload a file in Sugar as an attachment, it is stored against a Note record"

>> no, it wasn't but it isn't anymore. Sugar Sell 13 store Files elsewhere, not in the Notes module anymore (as It was under SugarCRM Pro 11).

Thanks, ciao

Ciao Manuel M ,

Thanks for the heads up.

I just opened the network tab on an instance on 13.2, created a note, with an attachment and it executed the same first APIs that I mentioned above.

There was a difference with the temp attachment linking when creating a new note (see screenshot below)

I suspect the previous method might still work for backward compatibility, but you never know (I have not tested it on 13.2).

If Zapier is "aware" of a method for storing attachments in Sugar, that would be it. See if that works!

And if it does not, then you might try something like Make which is the next step, above Zapier for automation and integrations, and see if that works for you.

Hope it helps

PS: Sugar is an API-based application, where the UI component lives in your browser and interacts with the backend via API only. The most efficient way to find out how to use the API is to look at the network tab while completing the action you want to replicate

Ciao Manuel M ,

Thanks for the heads up.

I just opened the network tab on an instance on 13.2, created a note, with an attachment and it executed the same first APIs that I mentioned above.

There was a difference with the temp attachment linking when creating a new note (see screenshot below)

I suspect the previous method might still work for backward compatibility, but you never know (I have not tested it on 13.2).

If Zapier is "aware" of a method for storing attachments in Sugar, that would be it. See if that works!

And if it does not, then you might try something like Make which is the next step, above Zapier for automation and integrations, and see if that works for you.

Hope it helps

PS: Sugar is an API-based application, where the UI component lives in your browser and interacts with the backend via API only. The most efficient way to find out how to use the API is to look at the network tab while completing the action you want to replicate

Ciao,

I see this call in the Network:

../rest/v11_20/Leads/temp/file/filename?platform=base

with filename parameter that carries a binary file:

I thin it's different by the official api call because when you click Browse and you select the file goes in a tmp folder. I don't know if I can access that folder via api but anyway, it's a different call (unofficial). 

Thanks for your advice about Make. We'll take a look. 

Grazie mille.