i have been able to get the contacts of a specific tag (group) using xmlRPC query on a table ContactGroupAssign.
i would like to know what is the field name and table name of Lead Status of a contact as shown:
also how can i get data from more than one table simultaneously .
i want to get some contacts data from table contact , appointments from ContactAction and the table contains Lead Status
and filter those data by tags with Lead Status value.
API Table searching is for individual tables. You will have to do several queries for this to work.
What you can do is to do a query say on the “Contact” table first, and collect the Contact IDs.
Then you pass an array of the Contact ID numbers into the Data Query parameter for the ContactAction table.