Read file attached to deal

[PedroTayer]

Hi guys,

I'm trying to read a file attached to a deal but I'm not being successful.

The API call I'm using is a get to:

/crm-associations/v1/associations/{deal_id}/HUBSPOT_DEFINED/11

But it returns just the notes ID, not the uploaded file ID.

In some posts I've read things about the file (when uploaded via UI) being hidden=true by default and the only solution to this was using an old HS interface.

I need to read a .csv file uploaded and attached to a deal via UI, is that possible?

[Jaycee_Lewis · Accepted solution]

Hey, Pedro! Thanks for reaching out. Did you get this worked out? If not, I followed the breadcrumbs and found at least one solution. 

Resources I used:

• The two endpoints mentioned here — How to get file attachments associated to a single deal with API
• This comment provided the last step — Access files via API. I took the attachment ID and used it here to get a link. The link allowed me to download the CSV from the Deal record.

Endpoints:

• https://legacydocs.hubspot.com/docs/methods/crm-associations/get-associations
• https://legacydocs.hubspot.com/docs/methods/engagements/get_engagement 
• https://legacydocs.hubspot.com/docs/methods/files/get-signed-url-private-file 

My steps:

• Created a new deal + added a CSV as an attachment to the deal via the UI 
• Used the Associations endpoint to find the engagement IDs 
• Used the Engagement endpoint to find the ID with a value for “attachments”
• Used the Get signed URL endpoint and the attachment ID to get a URL
• Used the URL to download the CSV

Requests:

1. 
2. 
3. 

    

Successful download

There isn't another all-in-one solution for this request. I agree, that would be a much more elegant and easier to deal with.

Have fun building! — Jaycee

[Nagashankar]

Been looking all over, and finally found this solution, thank you