Converting API fields to SQL for BI

Hi everyeone,

I’ve been working on a project where a client has many custom fields. The goal is to recreate the Restful data into several SQL tables . To do that, for example, I use the OrganizationFields to pull fields and data types for conversion. I actually create tables for enum types and build intermediary tables for set types.

What I’ve discovered is that the REST only returns a hand full of fields that make up the Organizations

In some cases, I have custom fields with no explanation of what the data is for example: “db5fbfe765f191995a9d2776405542b01fb036c6”: 617,

Am I missing something? Why are fields not described? How do I know what it is if there’s no meta describing it?

Thanks for any assistance!

Hi Garf,

Those returns are from Single Option or Multiple Option custom fields and the number you are seeing is the ID of the value inside the field.

You can use GET/organizationFields/{id} to get the details of a specific Field.

Thanks David,

Yes, totally get that. What I’m having problems with is that the organizational fields only hold a few of the organization fields that actually appear in a GET/Organizations. In many cases, I have a custom fields from the GET/Organizations “db5fbfe765f191995a9d2776405542b01fb036c6”: 617, that have no reference in GET]OrganizationFields.

How do I know what “db5fbfe765f191995a9d2776405542b01fb036c6”: 617 is?

It has no Id or type.

Thanks!
Garf

In this instance, db5fbfe765f191995a9d2776405542b01fb036c6 is the Field API Key, and 617 is the ID of the value in this Field.

Thanks David, so I totally understand the ID and value. I did from the start. No need to explain further.

You’re looking at a screen, and if I’m not mistaken, a Deals screen. Yet this field appeared when I pulled GET/Organizations. Remember, I’m strictly API and code in the background and I don’t know what it represents via the API at this point.

If I call the Get/OrganizationFields (makes sense because it appeared when I pulled Get/Organizations , this id does not appear in the fields for organizations. As a matter of fact, I just pulled Get/Dealfields and I still can’t locate it.

How do I discover what this field is and what represents via API? I need to map it to a name like “Transportation” and check it’s type to build the proper SQL for BI.

Does that make sense?

Truly appreciate your help!

Garf

If you’re pulling GET /OrganizationFields, each field will have a "key": where the Field API Key is shown and if it’s a Multiple/Single option field, it will also have "options": under that which will show the label connected to the IDs of the values in the Fields.

That’s what I thought too, but GET /OrganizationFields only gives me a limited set. How can I get all the fields? It’s not being limited either by the response dataset size.

{

"status": false,
"error": "Unknown method ."

}

Looking up a this field.

How can you tell that it is a limited set?

Perhaps you could show more of what the results you are getting are and I can examine it further?

Hi David,

I think what I’m seeing are deleted custom fields and how your system handles that. I’m not 100% sure, but it makes sense you would hold the data, stop displaying the field and remove it from the field list?

Here’s a sample record for Organizations and the organization fields after that. Let me know if you thing my hypothesis is correct.

{
  "id": 77,
  "company_id": 1246647,
  "owner_id": {
    "id": 1778630,
    "name": "House Account",
    "email": "sales@sales.com",
    "has_pic": true,
    "pic_hash": "36844e098aca2430fe3bb9bf95e2dcfe",
    "active_flag": true,
    "value": 1778630
  },
  "name": "Sample Company",
  "open_deals_count": 0,
  "related_open_deals_count": 0,
  "closed_deals_count": 0,
  "related_closed_deals_count": 0,
  "email_messages_count": 0,
  "people_count": 1,
  "activities_count": 0,
  "done_activities_count": 0,
  "undone_activities_count": 0,
  "reference_activities_count": 0,
  "files_count": 1,
  "notes_count": 0,
  "followers_count": 1,
  "won_deals_count": 0,
  "related_won_deals_count": 0,
  "lost_deals_count": 0,
  "related_lost_deals_count": 0,
  "active_flag": true,
  "category_id": null,
  "picture_id": null,
  "country_code": null,
  "first_char": "a",
  "update_time": "2019-03-20 02:42:02",
  "add_time": "2016-10-10 01:23:31",
  "visible_to": "3",
  "next_activity_date": null,
  "next_activity_time": null,
  "next_activity_id": null,
  "last_activity_id": null,
  "last_activity_date": null,
  "address": "",
  "address_subpremise": null,
  "address_street_number": null,
  "address_route": null,
  "address_sublocality": null,
  "address_locality": null,
  "address_admin_area_level_1": null,
  "address_admin_area_level_2": null,
  "address_country": null,
  "address_postal_code": null,
  "address_formatted_address": null,
  "2c04ebcd131fb7169dd3ecd56c98f89b57355db5": null,
  "efc8989b3bfd59b6fde66bc06452d6020cc9100e": null,
  "331cae2cd9a1dd6797a993fd19062b1570dbbc2c": null,
  "1697d2d33d86d1acc2fb65fd42cee4b7be0981a9": null,
  "42324f2d12796d12c832681722fb1479a8a00d89": null,
  "8aec27175807740bfafcee88120497dbafb14c74": null,
  "04c28f04432ab0c89009db7562a7495ffd725562": null,
  "6fcbfca36cf63744911edcdba285baa483cb96c2": null,
  "a257c1ba4d0ec4fc14304c5f7c683f3c198d1fd7": null,
  "label": null,
  "2182afab6fd0ccfffde795849f78cea475610f16": null,
  "a22c70332d9296537bcf341585eefb75ac7dd183": null,
  "a22c70332d9296537bcf341585eefb75ac7dd183_currency": null,
  "0fcda17f06af633534052924fa5af1960aa5b238": null,
  "0fcda17f06af633534052924fa5af1960aa5b238_currency": null,
  "6f70c8f57192a8f23645c3de67251082f9b3fd8a": null,
  "3596334cab8c160f2cb4c9654bc74d98866d3d5f": null,
  "c89efecdefc89218d442db559eb28c5ae107d830": null,
  "3516c0de7ffa3cfff2ac411cb02ed191ff2f4d68": null,
  "696b6b34773df382bfa65be52de809391056eede": null,
  "f815a0593832045c55bd004c7969ae8f85931bec": null,
  "b3419a4d8961b2aabcb55d83b35c43317c154239": null,
  "3bcae2f7b1fcb4c2d3dc3bf099b5620c0db2fcbd": null,
  "a54b3a807601129f35ab2f4c1c1863859eb9c430": null,
  "cb3c8b511c37a211f5d098c21bb036d7181af084": null,
  "db5fbfe765f191995a9d2776405542b01fb036c6": null,
  "owner_name": "House Account",
  "cc_email": "mail@mail.com"
}

Organization fields:
{
“success”: true,
“data”: [
{
“id”: 4038,
“key”: “cb3c8b511c37a211f5d098c21bb036d7181af084”,
“name”: “Stripe ID”,
“order_nr”: 2,
“field_type”: “varchar”,
“add_time”: “2019-05-07 16:03:56”,
“update_time”: “2019-05-07 16:04:00”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: true,
“searchable_flag”: true,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: false
},
{
“id”: 4037,
“key”: “a54b3a807601129f35ab2f4c1c1863859eb9c430”,
“name”: “Stripe URL”,
“order_nr”: 3,
“field_type”: “varchar”,
“add_time”: “2019-05-07 16:03:33”,
“update_time”: “2019-05-07 16:03:43”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: false
},
{
“id”: 4036,
“key”: “3bcae2f7b1fcb4c2d3dc3bf099b5620c0db2fcbd”,
“name”: “Segmentation”,
“order_nr”: 4,
“field_type”: “enum”,
“add_time”: “2019-03-20 02:35:07”,
“update_time”: “2019-08-22 14:27:15”,
“last_updated_by_user_id”: 1784346,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“label”: “Ad Agencies”,
“id”: 813
},
{
“label”: “Airport”,
“id”: 814
},
{
“label”: “Amusement”,
“id”: 815
},
{
“label”: “Bar/Club/Lounge”,
“id”: 816
},
{
“label”: “Camp”,
“id”: 817
},
{
“label”: “Casino”,
“id”: 818
},
{
“label”: “Competitor”,
“id”: 819
},
{
“label”: “Concrete”,
“id”: 857
},
{
“label”: “CTC Rental”,
“id”: 820
},
{
“label”: “Demolition”,
“id”: 864
},
{
“label”: “Developers”,
“id”: 821
},
{
“label”: “End User”,
“id”: 871
},
{
“label”: “Equip. Rental”,
“id”: 822
},
{
“label”: “Fence”,
“id”: 823
},
{
“label”: “Festivals”,
“id”: 824
},
{
“label”: “General Contractor”,
“id”: 825
},
{
“label”: “Gov Agency”,
“id”: 826
},
{
“label”: “High School”,
“id”: 827
},
{
“label”: “Home Owner”,
“id”: 828
},
{
“label”: “Hospital”,
“id”: 829
},
{
“label”: “Hotel”,
“id”: 830
},
{
“label”: “Lighting & Sound”,
“id”: 831
},
{
“label”: “Liquor”,
“id”: 879
},
{
“label”: “Marketing”,
“id”: 832
},
{
“label”: “Military”,
“id”: 833
},
{
“label”: “Municipality”,
“id”: 834
},
{
“label”: “Museum”,
“id”: 835
},
{
“label”: “Non-Profit”,
“id”: 836
},
{
“label”: “Parks & Rec”,
“id”: 837
},
{
“label”: “Police Department”,
“id”: 838
},
{
“label”: “Production Companies”,
“id”: 839
},
{
“label”: “Promotional Agency”,
“id”: 840
},
{
“label”: “Property Management”,
“id”: 841
},
{
“label”: “Races”,
“id”: 842
},
{
“label”: “Resellers”,
“id”: 843
},
{
“label”: “Restaurant”,
“id”: 844
},
{
“label”: “Retailer”,
“id”: 845
},
{
“label”: “Roofing”,
“id”: 856
},
{
“label”: “Safety”,
“id”: 846
},
{
“label”: “Sports”,
“id”: 847
},
{
“label”: “Telecommunications”,
“id”: 877
},
{
“label”: “University”,
“id”: 848
},
{
“label”: “Venues & Arenas”,
“id”: 850
},
{
“label”: “Wrestling”,
“id”: 849
}
],
“mandatory_flag”: false
},
{
“id”: 4035,
“key”: “b3419a4d8961b2aabcb55d83b35c43317c154239”,
“name”: “Industry”,
“order_nr”: 5,
“field_type”: “enum”,
“add_time”: “2019-03-20 02:33:27”,
“update_time”: “2019-08-20 20:33:44”,
“last_updated_by_user_id”: 1778630,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“label”: “Agriculture”,
“id”: 768
},
{
“label”: “Apparel and Fashion Goods”,
“id”: 769
},
{
“label”: “Automotive”,
“id”: 770
},
{
“label”: “Beauty and Personal Care”,
“id”: 771
},
{
“label”: “Building and Construction”,
“id”: 772
},
{
“label”: “Business Supplies”,
“id”: 773
},
{
“label”: “Chemicals”,
“id”: 774
},
{
“label”: “Computer Hardware”,
“id”: 775
},
{
“label”: “Construction”,
“id”: 776
},
{
“label”: “Consumer Electronics”,
“id”: 777
},
{
“label”: “Consumer Goods”,
“id”: 778
},
{
“label”: “Corporate”,
“id”: 779
},
{
“label”: “End User”,
“id”: 780
},
{
“label”: “Entertainment”,
“id”: 781
},
{
“label”: “Events”,
“id”: 782
},
{
“label”: “Food and Beverage”,
“id”: 783
},
{
“label”: “Freight and Logistics”,
“id”: 784
},
{
“label”: “Furniture”,
“id”: 785
},
{
“label”: “Health Care”,
“id”: 786
},
{
“label”: “Hospitality”,
“id”: 787
},
{
“label”: “Luxury Goods”,
“id”: 788
},
{
“label”: “Machinery”,
“id”: 789
},
{
“label”: “Manufacturing and Parts”,
“id”: 790
},
{
“label”: “Marketing”,
“id”: 868
},
{
“label”: “Medical Devices”,
“id”: 791
},
{
“label”: “Oil and Energy”,
“id”: 792
},
{
“label”: “Other”,
“id”: 793
},
{
“label”: “Packaging and Containers”,
“id”: 794
},
{
“label”: “Pet Products”,
“id”: 795
},
{
“label”: “Pharmaceuticals”,
“id”: 796
},
{
“label”: “Professional Services”,
“id”: 797
},
{
“label”: “Public Sector”,
“id”: 798
},
{
“label”: “Raw Materials”,
“id”: 799
},
{
“label”: “Real Estate”,
“id”: 800
},
{
“label”: “Religion”,
“id”: 801
},
{
“label”: “Rental”,
“id”: 802
},
{
“label”: “Reseller”,
“id”: 803
},
{
“label”: “Retail”,
“id”: 804
},
{
“label”: “School”,
“id”: 805
},
{
“label”: “Security”,
“id”: 806
},
{
“label”: “Shopping”,
“id”: 807
},
{
“label”: “Sporting Good”,
“id”: 808
},
{
“label”: “Textiles”,
“id”: 809
},
{
“label”: “Travel”,
“id”: 810
},
{
“label”: “Utility”,
“id”: 811
},
{
“label”: “Venues & Arenas”,
“id”: 812
}
],
“mandatory_flag”: false
},
{
“id”: 4026,
“key”: “2182afab6fd0ccfffde795849f78cea475610f16”,
“name”: “Payment Terms”,
“order_nr”: 6,
“field_type”: “enum”,
“add_time”: “2018-09-17 15:35:19”,
“update_time”: “2019-08-19 16:34:50”,
“last_updated_by_user_id”: 1778630,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“label”: “APRUVE”,
“id”: 872
},
{
“label”: “NET15”,
“id”: 650
},
{
“label”: “NET30”,
“id”: 651
},
{
“label”: “NET45”,
“id”: 652
},
{
“label”: “NET60”,
“id”: 653
},
{
“label”: “PRE-PAID”,
“id”: 649
}
],
“mandatory_flag”: false
},
{
“id”: 4002,
“key”: “id”,
“name”: “ID”,
“order_nr”: 7,
“picklist_data”: null,
“field_type”: “int”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 3993,
“key”: “name”,
“name”: “Name”,
“order_nr”: 8,
“picklist_data”: null,
“field_type”: “varchar”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: true,
“important_flag”: false,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“use_field”: “id”,
“link”: “/organization/”,
“mandatory_flag”: true
},
{
“id”: 4025,
“key”: “label”,
“name”: “Label”,
“order_nr”: 9,
“field_type”: “enum”,
“add_time”: “2018-09-12 10:32:54”,
“update_time”: null,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: false,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“color”: “green”,
“label”: “Customer”,
“id”: 645
},
{
“color”: “red”,
“label”: “Hot lead”,
“id”: 646
},
{
“color”: “yellow”,
“label”: “Warm lead”,
“id”: 647
},
{
“color”: “blue”,
“label”: “Cold lead”,
“id”: 648
}
],
“mandatory_flag”: false
},
{
“id”: 3994,
“key”: “owner_id”,
“name”: “Owner”,
“order_nr”: 10,
“picklist_data”: null,
“field_type”: “user”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: false,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“use_field”: “owner_id”,
“display_field”: “owner_name”,
“mandatory_flag”: true
},
{
“id”: 3995,
“key”: “people_count”,
“name”: “People”,
“order_nr”: 11,
“picklist_data”: null,
“field_type”: “double”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 3996,
“key”: “open_deals_count”,
“name”: “Open deals”,
“order_nr”: 12,
“picklist_data”: null,
“field_type”: “double”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 3997,
“key”: “add_time”,
“name”: “Organization created”,
“order_nr”: 13,
“picklist_data”: null,
“field_type”: “date”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 3998,
“key”: “update_time”,
“name”: “Update time”,
“order_nr”: 14,
“picklist_data”: null,
“field_type”: “date”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 3999,
“key”: “visible_to”,
“name”: “Visible to”,
“order_nr”: 15,
“field_type”: “visible_to”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2019-08-06 20:17:05”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“id”: 1,
“label”: “owner only”
},
{
“id”: 3,
“label”: “owner’s visibility group”
},
{
“id”: 5,
“label”: “owner’s visibility group and groups below”
},
{
“id”: 7,
“label”: “entire company”
}
],
“mandatory_flag”: true
},
{
“id”: 4000,
“key”: “next_activity_date”,
“name”: “Next activity date”,
“order_nr”: 16,
“picklist_data”: null,
“field_type”: “date”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4001,
“key”: “last_activity_date”,
“name”: “Last activity date”,
“order_nr”: 17,
“picklist_data”: null,
“field_type”: “date”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4003,
“key”: “won_deals_count”,
“name”: “Won deals”,
“order_nr”: 18,
“picklist_data”: null,
“field_type”: “int”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4004,
“key”: “lost_deals_count”,
“name”: “Lost deals”,
“order_nr”: 19,
“picklist_data”: null,
“field_type”: “int”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4005,
“key”: “closed_deals_count”,
“name”: “Closed deals”,
“order_nr”: 20,
“picklist_data”: null,
“field_type”: “int”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4006,
“key”: “activities_count”,
“name”: “Total activities”,
“order_nr”: 21,
“picklist_data”: null,
“field_type”: “int”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4007,
“key”: “done_activities_count”,
“name”: “Done activities”,
“order_nr”: 22,
“picklist_data”: null,
“field_type”: “int”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4008,
“key”: “undone_activities_count”,
“name”: “Activities to do”,
“order_nr”: 23,
“picklist_data”: null,
“field_type”: “int”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4009,
“key”: “email_messages_count”,
“name”: “Email messages count”,
“order_nr”: 24,
“picklist_data”: null,
“field_type”: “int”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4010,
“key”: “picture_id”,
“name”: “Profile picture”,
“order_nr”: 25,
“picklist_data”: null,
“field_type”: “picture”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: false,
“add_visible_flag”: false,
“important_flag”: false,
“bulk_edit_allowed”: false,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: true
},
{
“id”: 4011,
“key”: “address”,
“name”: “Address”,
“order_nr”: 26,
“picklist_data”: null,
“field_type”: “address”,
“add_time”: “2016-10-03 14:21:50”,
“update_time”: “2016-10-03 14:21:33”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: false,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: false,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: false
},
{
“id”: null,
“key”: “address_subpremise”,
“name”: “Apartment/suite no”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_street_number”,
“name”: “House number”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_route”,
“name”: “Street/road name”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_sublocality”,
“name”: “District/sublocality”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_locality”,
“name”: “City/town/village/locality”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_admin_area_level_1”,
“name”: “State/county”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_admin_area_level_2”,
“name”: “Region”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_country”,
“name”: “Country”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_postal_code”,
“name”: “ZIP/Postal code”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: null,
“key”: “address_formatted_address”,
“name”: “Full/combined address”,
“field_type”: “varchar”,
“edit_flag”: false,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: true
},
{
“id”: 4016,
“key”: “efc8989b3bfd59b6fde66bc06452d6020cc9100e”,
“name”: “Type”,
“order_nr”: 27,
“field_type”: “enum”,
“add_time”: “2016-10-20 21:34:01”,
“update_time”: “2016-10-20 21:34:05”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“label”: “Private”,
“id”: 134
},
{
“label”: “Public”,
“id”: 135
}
],
“mandatory_flag”: false
},
{
“id”: 4019,
“key”: “1697d2d33d86d1acc2fb65fd42cee4b7be0981a9”,
“name”: “Company Size”,
“order_nr”: 28,
“field_type”: “enum”,
“add_time”: “2016-11-10 17:20:31”,
“update_time”: “2016-11-30 14:51:42”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“label”: “5001-10,000”,
“id”: 487
},
{
“label”: “1001-5000”,
“id”: 488
},
{
“label”: “501-1000”,
“id”: 489
},
{
“label”: “201-500”,
“id”: 490
},
{
“label”: “51-200”,
“id”: 491
},
{
“label”: “11-50”,
“id”: 492
},
{
“label”: “1-10”,
“id”: 493
},
{
“label”: “Self-employed”,
“id”: 494
}
],
“mandatory_flag”: false
},
{
“id”: 4020,
“key”: “42324f2d12796d12c832681722fb1479a8a00d89”,
“name”: “Capacity”,
“order_nr”: 29,
“field_type”: “enum”,
“add_time”: “2016-11-10 17:22:01”,
“update_time”: “2017-02-10 20:03:55”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“label”: “1,500-”,
“id”: 526
},
{
“label”: “2,500”,
“id”: 477
},
{
“label”: “5,000”,
“id”: 478
},
{
“label”: “7,500”,
“id”: 479
},
{
“label”: “10,000”,
“id”: 480
},
{
“label”: “12,500”,
“id”: 481
},
{
“label”: “15,000”,
“id”: 482
},
{
“label”: “17,500”,
“id”: 483
},
{
“label”: “20,000”,
“id”: 484
},
{
“label”: “50,000+”,
“id”: 525
}
],
“mandatory_flag”: false
},
{
“id”: 4023,
“key”: “6fcbfca36cf63744911edcdba285baa483cb96c2”,
“name”: “website”,
“order_nr”: 30,
“field_type”: “varchar”,
“add_time”: “2016-11-30 15:02:23”,
“update_time”: “2018-09-17 15:35:34”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: true,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: true,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: false
},
{
“id”: 4027,
“key”: “a22c70332d9296537bcf341585eefb75ac7dd183”,
“name”: “Current Credit”,
“order_nr”: 31,
“picklist_data”: null,
“field_type”: “monetary”,
“add_time”: “2018-10-30 15:09:05”,
“update_time”: “2018-10-30 15:17:14”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: false,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: false
},
{
“id”: null,
“key”: “a22c70332d9296537bcf341585eefb75ac7dd183_currency”,
“name”: “Currency of Current Credit”,
“field_type”: “varchar”,
“edit_flag”: true,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: false
},
{
“id”: 4028,
“key”: “0fcda17f06af633534052924fa5af1960aa5b238”,
“name”: “Current Balance”,
“order_nr”: 32,
“picklist_data”: null,
“field_type”: “monetary”,
“add_time”: “2018-10-30 15:14:11”,
“update_time”: “2018-10-30 15:17:07”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: false,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: false
},
{
“id”: null,
“key”: “0fcda17f06af633534052924fa5af1960aa5b238_currency”,
“name”: “Currency of Current Balance”,
“field_type”: “varchar”,
“edit_flag”: true,
“active_flag”: true,
“is_subfield”: true,
“mandatory_flag”: false
},
{
“id”: 4029,
“key”: “6f70c8f57192a8f23645c3de67251082f9b3fd8a”,
“name”: “Account Status”,
“order_nr”: 33,
“field_type”: “set”,
“add_time”: “2018-10-30 15:16:38”,
“update_time”: “2018-10-30 15:17:02”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: false,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: false,
“filtering_allowed”: true,
“sortable_flag”: true,
“options”: [
{
“label”: “Credit Hold”,
“id”: 670
},
{
“label”: “Active”,
“id”: 671
},
{
“label”: “Blocked”,
“id”: 672
}
],
“mandatory_flag”: false
},
{
“id”: 4032,
“key”: “3516c0de7ffa3cfff2ac411cb02ed191ff2f4d68”,
“name”: “Mac Customer Number”,
“order_nr”: 34,
“picklist_data”: null,
“field_type”: “varchar”,
“add_time”: “2019-01-09 15:37:33”,
“update_time”: “2019-01-09 15:37:32”,
“last_updated_by_user_id”: null,
“active_flag”: true,
“edit_flag”: true,
“index_visible_flag”: true,
“details_visible_flag”: true,
“add_visible_flag”: false,
“important_flag”: true,
“bulk_edit_allowed”: true,
“searchable_flag”: true,
“filtering_allowed”: true,
“sortable_flag”: true,
“mandatory_flag”: false
}
],
“additional_data”: {
“pagination”: {
“start”: 0,
“limit”: 100,
“more_items_in_collection”: false
}
}
}

Hey Garf,

Sorry for the wait. I looked over what you sent, but I don’t see anything that goes back to the original problem you had

In some cases, I have custom fields with no explanation of what the data is for example: “db5fbfe765f191995a9d2776405542b01fb036c6”: 617,

Can you point to a particular part in your response that goes back to that?