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
}
}
}