How to find attribute IDs for specific attributes

Question

We had to request a backup copy of our database recently for a deleted record. I'm trying to get back the attribute/custom fields. By process of elimination I was able to figure out 5 of the 10, but the remaining 5 have no text or comments in the fields only the Attributes ID and Attribute Types ID. Anyone have any magic insight as to where I find those. When I try querying, it appears only the attribute import ID comes out which is not what I'm looking for. Thanks in advance!

Alex Wong · Accepted Answer

not exactly sure what you are trying to do, but if you want the attribute id, that's not the same as *** attribute import id (i.e. Consittuent Attribute Import ID). Attribute ID is the ID assigned to the attribute category, not the individual attribute for a constituent record.

If you are on RE NXT, you can use Query, select the attribute (custom field) category's description or any field) as filter or output, then go to Option and Copy JSON. paste into notepad.

the unique_id is the attribute id

Denise Miller · Accepted Answer

Thank you @Alex Wong! What I had been trying to do, was from the record that no longer existed within RE/NXT, the backup file had many code #s/IDs for the various fields but did not give the actual field names. Our IT department was able to provide most of the data but I was trying to figure out where to get some of the actual table names that the code #s referenced. It was from that information by process of elimination I was able to decipher what the field names were. Our IT department had been extremely helpful in securing the backup and finding that missing record, I was trying to be proactive in not having to ask them for additional data. :)  Appreciate this community!