Hello, I have spent much time trying to import data to HubSpot via Python 3.7. I was successful at importing the csv via the HubSpot UI. However, I keep getting a 400 request with "unable to process json" comment. I created the custom properties "policycount_SW" and "GWP_SW" within Hubspot already.
@dennisedson I wouldn't say I'm an Expert just yet. 😉
@dornan1 In looking at your JSON, it appears as though you have an extra closing bracket } at the end. Also JSON likes for your literal values to be lowercase (the True and False). Try this:
Sep 22, 20202:00 PM - edited Sep 23, 20209:45 AM
Participant
Unable to import data into Hubspot via Python 3.7
Hi @dennisedson and @taran42, thank you for your suggestions. Unfortunately, I'm still getting a 'bad request' return with a "some property names are invalid." However, these names are the same (case/spelling) as in Hubspot. I have imported the same file after initially being unsuccessful. I switched the Name/Company ID fields so that ID was first.
However, this is the Python error I'm getting:
{"status":"error","message":"some property names are invalid: {ObjectTypeId{legacyObjectType=COMPANY}=[Company Domain, claimcount_SW, COMPANY ID, Name]}","correlationId":"3da5f8a9-5d5a-44ae-9740-5837a981f78a"}