topic Re: Import a list of contacts using a csv file OAuth in APIs & Integrations

Import a list of contacts using a csv file OAuth

AbdelMOULIDA — Wed, 09 Nov 2022 14:37:36 GMT

Hello,

As HubSpot is going to remove the use of API keys I find myself in a situation to change all my scripts.

In this example, I pass the API key in the URL (url variable), now with the OAuth Access Token I don't know how and where to put it to be able to do my contact import.

Thanks for your help.

# .CV file / contacts to import url = "https://api.hubapi.com/crm/v3/imports?hapikey=MYAPIKEY" data = { "name": "users_import", # import name "files": [ { "fileName": "previousdayusers.csv", # .csv filename "fileFormat": "CSV", "fileImportPage": { "hasHeader": True, "columnMappings": [ { "ignored": False, "columnName": "firstname", "idColumnType": None, "propertyName": "firstname", "foreignKeyType": None, "columnObjectType": "CONTACT", "associationIdentifierColumn": False }, { "ignored": False, "columnName": "lastname", "idColumnType": None, "propertyName": "lastname", "foreignKeyType": None, "columnObjectType": "CONTACT", "associationIdentifierColumn": False }, { "ignored": False, "columnName": "email", "idColumnType": "HUBSPOT_ALTERNATE_ID", "propertyName": "email", "foreignKeyType": None, "columnObjectType": "CONTACT", "associationIdentifierColumn": False } ] } } ]} # preparing the JSON file / data datastring = json.dumps(data) payload = {"importRequest": datastring} files = [('files', open('previousdayusers.csv','rb'))] # .csv filename # pushing the contacts response = requests.request("POST", url, data = payload, files = files) print(response.text.encode('utf8')) print(response.status_code)

Re: Import a list of contacts using a csv file OAuth

AbdelMOULIDA — Wed, 09 Nov 2022 15:03:22 GMT

@dennisedson @webdew Need your help guys 🙏

Re: Import a list of contacts using a csv file OAuth

dennisedson — Wed, 09 Nov 2022 15:31:52 GMT

@AbdelMOULIDA ,

I am not a python wizard. Heck I am not even a python wizards apprentice 🤣,

But I think I can help a bit here.

First of all, need to understand if you are doing this for a public facing app or if this is for a single portal. If it is for a public facing app that will be used across many portals, you will need to walk through the process of setting up oauth. Here is a link to the quickstart guide.

Setting up a public app is more involved due to oauth.

If you are setting this up for a single portal, then you would want to reach for a private app. Here is a link to getting started with private apps.

Setting up a private app is a much more straight forward process. When you create a private app, you will need to identify the scopes for you need then you will be given an access token that you will include in your data being sent as a bearer token in the header.

Here is a stackoverflow link regarding sending a bearer token with Python.

@taran42 and @zaklein are both better equipped to answer more Python specific questions than I. Give me a few years and hopefully I will have learned Python. It has been on my bucket list for a LONG time.

Good luck out there!

Re: Import a list of contacts using a csv file OAuth

AbdelMOULIDA — Wed, 09 Nov 2022 15:38:18 GMT

Thank you @dennisedson for your feedback.

Okay 😅, no problem.

I will wait for help from @taran42 and @zaklein because I have trouble understanding understanding how to follow the steps of private apps.

For information, It's a python script that I'm executing automatically once per day to import contact to HubSpot.