I'm using python to retrive contacts data and storing into a .json file using the following code:
with open('contatos.json',"w", encoding='utf-8') as outfile:
for item in contact_list:
json.dump(item, outfile, ensure_ascii=False)
outfile.write('\n')
I'm reading the .json file in Qlik Sense and i notice that for the field "properties" there are more then one possible value. Actually this is not happening only for this field.
In get call of a contact, we get a detailed response from API and that includes almost all the contact properties associated with a record. In api response for getting a contact, we have a specific index for properties and then under fhis all the default as well as custom properties with label, internal name and value are listed. So in order to store contact data into a json file, you need to loop the properties index as well.
In get call of a contact, we get a detailed response from API and that includes almost all the contact properties associated with a record. In api response for getting a contact, we have a specific index for properties and then under fhis all the default as well as custom properties with label, internal name and value are listed. So in order to store contact data into a json file, you need to loop the properties index as well.