Hi

I’m needing some help with either API or a way to change the pipped text code.

Use case:

I’m getting information from HubSpot. I’m not able to use the Hubspot task in the workflow as it is not a list of contacts that I can bring, but data based in an Hubspot Object. As a solution, the Hubspot team suggested to use the following API: https://api.hubapi.com/crm/v3/objects/p143360983_medis_appointment?limit=100&properties=appointmentid,appointmenttype,appointmentstatus,eventcode,clientnif,clientcontacttlm,clientemail,professionallicensenumber,providernif,hs_pipeline,hs_pipeline_stage,date_concluida,first_name

This the API is returning the info needed for my “list” of contacts - contact info and all the properties I need to create a list in Qualtrics.

The issue: as the API is returning the different “contacts” divided in $.resultsn0]; $.results;1]; $.results;2]; etc. I’m not able to use the task Update XM Directory contacts because in the Pipped Text I need to choose for each XM Directory filed a specific Source field -  eg: for First Name, I need to pipe text ~{ch://OCAC_zg3WUnKycgIGa27/$.resultsW0].properties.first_name}

Doing so, I’m only bringing the 1st “contact” info, not the following ones  $.resultsh1]…; $.resultse2]….

Is there a way to use Pipped Text but replacing something so that Qualtrics recognises this is an array? I’ve tried to delete the “ 0]”, also placing it as “