I did not limit columns. Here is the Raw output from the Get Rows
{
"statusCode": 200,
"headers": {
"Cache-Control": "no-cache",
"Vary": "Accept-Encoding",
"Set-Cookie": "ARRAffinity=659b47fe69391b93c57b60043286d4ea36dea61b01ed40eff647002271b4b76c15134d20c556b0b34b9b6ae43ec3f5dcdad61788de889ffc592af7aca85fc1c508DC98908F6F3F551075409532; path=/; secure; HttpOnly,ReqClientId=16eff2c7-bfb3-4895-8f4d-3f8d8c4ebd19; expires=Fri, 29-Jun-2074 22:39:42 GMT; path=/; secure; HttpOnly,ARRAffinity=659b47fe69391b93c57b60043286d4ea36dea61b01ed40eff647002271b4b76c15134d20c556b0b34b9b6ae43ec3f5dcdad61788de889ffc592af7aca85fc1c508DC98908F6F3F551075409532; path=/; secure; HttpOnly",
"x-ms-service-request-id": "f8e3fa6e-e626-4a76-82e4-c11692351555",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"REQ_ID": "f8e3fa6e-e626-4a76-82e4-c11692351555",
"CRM.ServiceId": "CRMAppPool",
"AuthActivityId": "43c664b1-ff64-495d-a78e-f8051ee221aa",
"x-ms-dop-hint": "4",
"x-ms-ratelimit-time-remaining-xrm-requests": "1,200.00",
"x-ms-ratelimit-burst-remaining-xrm-requests": "7999",
"OData-Version": "4.0",
"Preference-Applied": "odata.include-annotations=\"*\"",
"X-Source": "17314419240125132190941551574325193231691442252021471796668665217819741170511007137,151253892395317710912462318544921054013110723315846901862511471021661011616312433234",
"Public": "OPTIONS,GET,HEAD,POST",
"Date": "Sat, 29 Jun 2024 22:39:43 GMT",
"Allow": "OPTIONS,GET,HEAD,POST",
"Content-Type": "application/json; odata.metadata=full",
"Content-Length": "33128",
"Expires": "-1"
},
"body": {
"#Microsoft.Dynamics.CRM.CreateMultiple": {
"title": "CreateMultiple",
},
"#Microsoft.Dynamics.CRM.DeleteMultiple": {
"title": "DeleteMultiple",
},
"#Microsoft.Dynamics.CRM.UpdateMultiple": {
"title": "UpdateMultiple",
},
"#Microsoft.Dynamics.CRM.UpsertMultiple": {
"title": "UpsertMultiple",
},
"@Microsoft.Dynamics.CRM.totalrecordcount": -1,
"@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded": false,
"@Microsoft.Dynamics.CRM.globalmetadataversion": "3246981",
"value": [
{
"@odata.type": "#Microsoft.Dynamics.CRM.account",
"@odata.etag": "W/\"3218858\"",
"@odata.editLink": "accounts(4bd0aac3-5f32-ef11-8e4e-002248b294e6)",
"territorycode@OData.Community.Display.V1.FormattedValue": "Default Value",
"territorycode": 1,
"address2_freighttermscode@OData.Community.Display.V1.FormattedValue": "Default Value",
"address2_freighttermscode": 1,
"address2_shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
"address2_shippingmethodcode": 1,
"accountid@odata.type": "#Guid",
"accountid": "4bd0aac3-5f32-ef11-8e4e-002248b294e6",
"followemail@OData.Community.Display.V1.FormattedValue": "Allow",
"followemail": true,
"donotbulkemail@OData.Community.Display.V1.FormattedValue": "Allow",
"donotbulkemail": false,
"donotsendmm@OData.Community.Display.V1.FormattedValue": "Send",
"donotsendmm": false,
"createdon@OData.Community.Display.V1.FormattedValue": "6/24/2024 1:27 PM",
"createdon@odata.type": "#DateTimeOffset",
"createdon": "2024-06-24T19:27:24Z",
"preferredcontactmethodcode@OData.Community.Display.V1.FormattedValue": "Any",
"preferredcontactmethodcode": 1,
"statecode@OData.Community.Display.V1.FormattedValue": "Active",
"statecode": 0,
"businesstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
"businesstypecode": 1,
"donotpostalmail@OData.Community.Display.V1.FormattedValue": "Allow",
"donotpostalmail": false,
"donotbulkpostalmail@OData.Community.Display.V1.FormattedValue": "No",
"donotbulkpostalmail": false,
"_ownerid_value@OData.Community.Display.V1.FormattedValue": "Shayne MacDonald",
"_ownerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ownerid",
"_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_ownerid_value@odata.type": "#Guid",
"_ownerid_value": "88384726-abec-ee11-a1fd-000d3ae91fb8",
"address1_line1": "108-10466 Fulton DR.",
"name": "HDD PRO",
"address1_city": "Acheson",
"donotemail@OData.Community.Display.V1.FormattedValue": "Allow",
"donotemail": false,
"address1_composite": "108-10466 Fulton DR.\r\nAcheson, Alberta",
"address2_addresstypecode@OData.Community.Display.V1.FormattedValue": "Default Value",
"address2_addresstypecode": 1,
"donotphone@OData.Community.Display.V1.FormattedValue": "Allow",
"donotphone": false,
"emailaddress1": "jonathan@hddpro.ca",
"statuscode@OData.Community.Display.V1.FormattedValue": "Active",
"statuscode": 1,
"_modifiedby_value@OData.Community.Display.V1.FormattedValue": "Shayne MacDonald",
"_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_modifiedby_value@odata.type": "#Guid",
"_modifiedby_value": "88384726-abec-ee11-a1fd-000d3ae91fb8",
"shippingmethodcode@OData.Community.Display.V1.FormattedValue": "Default Value",
"shippingmethodcode": 1,
"modifiedon@OData.Community.Display.V1.FormattedValue": "6/24/2024 1:27 PM",
"modifiedon@odata.type": "#DateTimeOffset",
"modifiedon": "2024-06-24T19:27:24Z",
"_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue": "orgeee4ebda",
"_owningbusinessunit_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "owningbusinessunit",
"_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit",
"_owningbusinessunit_value@odata.type": "#Guid",
"_owningbusinessunit_value": "9fb828a2-d0e8-ee11-a204-000d3ae8898f",
"telephone1": "780-293-3468",
"versionnumber@OData.Community.Display.V1.FormattedValue": "3,218,858",
"versionnumber@odata.type": "#Int64",
"versionnumber": 3218858,
"_createdby_value@OData.Community.Display.V1.FormattedValue": "Shayne MacDonald",
"_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_createdby_value@odata.type": "#Guid",
"_createdby_value": "88384726-abec-ee11-a1fd-000d3ae91fb8",
"donotfax@OData.Community.Display.V1.FormattedValue": "Allow",
"donotfax": false,
"merged@OData.Community.Display.V1.FormattedValue": "No",
"merged": false,
"customersizecode@OData.Community.Display.V1.FormattedValue": "Default Value",
"customersizecode": 1,
"marketingonly@OData.Community.Display.V1.FormattedValue": "No",
"marketingonly": false,
"accountratingcode@OData.Community.Display.V1.FormattedValue": "Default Value",
"accountratingcode": 1,
"address2_addressid@odata.type": "#Guid",
"address2_addressid": "1264203f-108f-4e9e-9b34-79795eda9373",
"_owninguser_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_owninguser_value@odata.type": "#Guid",
"_owninguser_value": "88384726-abec-ee11-a1fd-000d3ae91fb8",
"creditonhold@OData.Community.Display.V1.FormattedValue": "No",
"creditonhold": false,
"participatesinworkflow@OData.Community.Display.V1.FormattedValue": "No",
"participatesinworkflow": false,
"accountclassificationcode@OData.Community.Display.V1.FormattedValue": "Default Value",
"accountclassificationcode": 1,
"address1_addressid@odata.type": "#Guid",
"address1_addressid": "e54b447c-d5e8-4eda-86b7-a57418c9fd2d",
"address1_stateorprovince": "Alberta",
}
]
}
}
__________________________
I brought up the Search box in the Raw Output and did a search for address1_ and it gives 6 results, none of them are the postal code. If I do the search for address1_postalcode it comes back with 0 Results.
