CiviCRM Community Forums (archive)

I am having a hard time figuring out how to pull custom fields that are associated with an address (rather than a contact) via the API. A regular Address > Get doesn't pull the custom fields, and a Custom Value > Get doesn't seem to work (or I don't know how to pull it out of there correctly at any rate).

Has anyone done this before?

Thanks, Coleman. I have been trying in the API Explorer to no avail. With Custom Value > Get, I've tried:

• entity_id = id (from the civicrm_address table for the relevant address; but it pulls up info for custom contact fields for a contact_id instead of an address id)
• entity_id = contact_id (for the relevant contact; and although it returns custom values associated with the contact directly, it does not return the ones associated with the contact's address)
• entity_id = contact_id & return.custom_X=1 (for the relevant contact; returns 0)

Maybe you have an idea what I'm doing wrong. (For what it's worth, this happens on the demo site, too).

Your first one was right, you just need to tell it the type of entity (it defaults to Contact)
entity_id = id & entity_table = 'civicrm_address'

Pete - custom address fields have been around for a while - where have you been?

Bingo! Thanks Coleman!

I added a comment on this page, as the "implicit entity_table detection" it describes under "Custom Data Retrieval Examples" doesn't work for me.

"*If implicit entity_table detection is not working, specify the entity_table to be sure. (e.g. /civicrm/ajax/rest?json=1&sequential=1&debug=1&&entity=CustomValue&action=get&entity_table=Address&entity_id=15166&return.custom_138=1"

Your first one was right, you just need to tell it the type of entity (it defaults to Contact)
entity_id = id & entity_table = 'civicrm_address'

Pete - custom address fields have been around for a while - where have you been?