Problem mapping Societeinfo API data in HubSpot CRM via Make

Hello everyone,

I am currently working on a workflow in Make to integrate financial data from the Societeinfo API directly into our HubSpot CRM. The process involves retrieving a list of data via the API and updating it in the company records on HubSpot.

I am able to obtain the required data from the Societeinfo API, but I am encountering a problem when mapping these data in the “Update a Company” module of HubSpot CRM: the complete list of data is not available for mapping.

Here are the steps I have followed:

  • Use of the “Custom Webhook” module to trigger the scenario (via a HubSpot app that detects the change of a property).
  • Retrieval of the HubSpot ID of the object concerned by the property change as well as data that allows searching for it on Societeinfo.
  • Retrieval of data from the API with the “HTTP > Make an API Key Auth request” module, using the data taken from HubSpot just before.
  • Attempt to map the received data in the “Update a Company” module of HubSpot.

For your information, I am using the Societeinfo API documentation available here: Documentation API | SocieteInfo

Has anyone else encountered this problem or have an idea on how to make all the fields of data appear for mapping in HubSpot CRM? Any help or suggestion would be greatly appreciated.

Thank you in advance for your time and assistance.

Screenshots to illustrate my problem :
Workflow : https://image.noelshack.com/fichiers/2024/11/1/1710174864-capture-d-ecran-2024-03-11-a-16-54-36.png
What I get from Societeinfo on the HTTP module : https://image.noelshack.com/fichiers/2024/11/1/1710175023-image-1.png
What i get after on the Update a company module : https://image.noelshack.com/fichiers/2024/11/1/1710175237-image-2.png
(as you can see, I don’t have access to as many datas (groups 1, 2, 3, etc…))