topic Re: Python - help uploading a file via CMS API in APIs & Integrations

Python - help uploading a file via CMS API

PedroTayer — Sat, 29 Oct 2022 14:55:20 GMT

Hi guys, I'm trying to upload a .csv file to file manager via https://developers.hubspot.com/docs/api/files/files but I get a 400. The lack of example on documentation made me come here.

My headers and url are:

headers = {'content-type' : 'multipart/form-data', 'authorization': myauth}
url = 'https://api.hubapi.com/files/v3/files'

Im trying to:

with open(path_to_csv_file) as fh:
    data = {'file': fh,
            'folderId': '89858067367',
            'fileName': 'test',
            'options': json.dumps({
                'access': 'PRIVATE',
                'overwrite': False,
                'duplicateValidationStrategy': 'NONE',
                'duplicateValidationScope': 'EXACT_FOLDER'
            })
            }

    req = requests.post(url, files=data, headers=headers)

Where am I goind wrong?

Re: Python - help uploading a file via CMS API

Jaycee_Lewis — Mon, 31 Oct 2022 15:42:14 GMT

Hi, @PedroTayer 👋 Thanks for reaching out! Hey, @taran42 @JBeatty, do you have any experience or troubleshooting tips you can share with @PedroTayer?

Thank you very much! — Jaycee

Re: Python - help uploading a file via CMS API

JBeatty — Mon, 31 Oct 2022 19:33:29 GMT

Hi @PedroTayer,

2 things, first you don't want to specify the content type, because for multipart/form-data encoding that contains the boundary and you are overwriting that, and secondly you want to use the files parameter for the post function to tell requests to do multipart/form-data. Here is some sample code I got working:

import json, requests, os BEARER_TOKEN = os.environ['BEARER_TOKEN'] headers = {'authorization': "Bearer " + BEARER_TOKEN} url = 'https://api.hubapi.com/files/v3/files' with open("test.txt") as fh: files = {'file': fh} data = { 'folderId': '', 'fileName': 'testFileName', 'options': json.dumps({ 'access': 'PRIVATE', 'overwrite': False, 'duplicateValidationStrategy': 'NONE', 'duplicateValidationScope': 'EXACT_FOLDER' }) } resp = requests.post(url, files=files, data=data, headers=headers)

Best,

Re: Python - help uploading a file via CMS API

PedroTayer — Mon, 31 Oct 2022 23:26:09 GMT

Thank you very much it worked! I've uploaded it and associated with deal using v1 engagement considering the file as a note.

Just another thing, might help someone, I've managed to upload the file directly from a dataframe by using (the encoding is according to portuguese-br):

import io
csv_buffer = io.BytesIO()
df.to_csv(csv_buffer, sep=",", index=False, mode="wb", encoding="ISO-8859-1")
csv_buffer.seek(0)

files = {'file': csv_buffer}