Hi,
@Ramesh Kumar, I don't wish to change a contact to a company. Thank you for your response.
You can change Contact type to person or company
Thanks,
@RockwithNav, I have yzhums on speeddial and had read that very article ... should've listed it ... thanks though!
I appreciate the long response, but I should have stated in my question that I won't accept information from AI generated content. Thank you, though,
@Sumit Singh.
When you create ...
...
... If you're using the API, make sure to
That being said, the API steps are logic that I should have got to, I just got so frustrated at the ridiculousness of the GUI. 😏
Either way, the Customer is not linked to a Company in any way, whatsoever.
...
Also, case in point on the AI stuff (sorry to do this here) ... the API does not list companyId as a field that you can set for the contact endpoint, here.
Additionally, I pulled a schema of the contacts endpoint, and it is not a field that is available according to this:
{
"body": {
"name": "contacts",
"title": "Contact",
"x-ms-permission": "read-write",
"x-ms-capabilities": {
"sortRestrictions": {
"sortable": true
},
"filterRestrictions": {
"filterable": true
},
"selectRestrictions": {
"selectable": true
},
"filterFunctionSupport": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
],
"serverPagingOptions": [
"skiptoken"
]
},
"schema": {
"x-ms-permission": "read-write",
"type": "array",
"items": {
"type": "object",
"required": [],
"properties": {
"id": {
"title": "Id",
"type": "string",
"x-ms-sort": "asc,desc",
"format": "guid",
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or"
]
},
"x-ms-permission": "read-only",
"x-ms-keyType": "primary",
"x-ms-keyOrder": 1
},
"number": {
"title": "No.",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 20,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"type": {
"title": "Type",
"type": "string",
"x-ms-sort": "none",
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or"
]
},
"x-ms-permission": "read-write"
},
"displayName": {
"title": "Display Name",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 100,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"jobTitle": {
"title": "Job Title",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 30,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"companyNumber": {
"title": "Company Number",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 20,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"companyName": {
"title": "Company Name",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 100,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"contactBusinessRelation": {
"title": "Business Relation",
"type": "string",
"x-ms-sort": "none",
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or"
]
},
"x-ms-permission": "read-write"
},
"addressLine1": {
"title": "Address Line 1",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 100,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"addressLine2": {
"title": "Address Line 2",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 50,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"city": {
"title": "City",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 30,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"state": {
"title": "State",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 30,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"country": {
"title": "Country/Region Code",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 10,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"postalCode": {
"title": "Postcode",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 20,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"phoneNumber": {
"title": "Phone No.",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 30,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"mobilePhoneNumber": {
"title": "Mobile Phone No.",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 30,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"email": {
"title": "Email",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 80,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"website": {
"title": "Website",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 80,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"searchName": {
"title": "Search Name",
"type": "string",
"x-ms-sort": "asc,desc",
"maxLength": 100,
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"privacyBlocked": {
"title": "Privacy Blocked",
"type": "boolean",
"x-ms-sort": "asc,desc",
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or"
]
},
"x-ms-permission": "read-write"
},
"taxRegistrationNumber": {
"title": "VAT Registration No.",
"type": "string",
"x-ms-sort": "asc,desc",
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or",
"contains",
"endswith",
"startswith",
"substring",
"tolower",
"toupper"
]
},
"x-ms-permission": "read-write"
},
"lastInteractionDate": {
"title": "Date of Last Interaction",
"type": "string",
"x-ms-sort": "asc,desc",
"format": "date",
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or"
]
},
"x-ms-permission": "read-write"
},
"lastModifiedDateTime": {
"title": "Last Modified Date",
"type": "string",
"x-ms-sort": "asc,desc",
"format": "date-time",
"x-ms-capabilities": {
"filterFunctions": [
"eq",
"ne",
"gt",
"ge",
"lt",
"le",
"and",
"or"
]
},
"x-ms-permission": "read-write"
}
},
"x-ms-displayFormat": {
"propertiesCompactDisplayOrder": [
"id",
"number",
"type"
],
"propertiesDisplayOrder": [
"id",
"number",
"type",
"displayName",
"jobTitle",
"companyNumber",
"companyName",
"contactBusinessRelation",
"addressLine1",
"addressLine2",
"city",
"state",
"country",
"postalCode",
"phoneNumber",
"mobilePhoneNumber",
"email",
"website",
"searchName",
"privacyBlocked"
],
"propertiesTabularDisplayOrder": [
"id",
"number",
"type",
"displayName",
"jobTitle",
"companyNumber",
"companyName",
"contactBusinessRelation",
"addressLine1",
"addressLine2",
"city",
"state",
"country",
"postalCode",
"phoneNumber",
"mobilePhoneNumber",
"email",
"website",
"searchName",
"privacyBlocked"
]
}
}
}
}
}
Further more, the EDMX readout for the contacts endpoint shows no connection to that data, either ... at least that I can find ... but EDMX is horrrrrrrible. :sweat_smile:
<EntityType Name="contact">
<Key>
<PropertyRef Name="id" />
</Key>
<Property Name="id" Type="Edm.Guid" Nullable="false" />
<Property Name="number" Type="Edm.String" MaxLength="20" />
<Property Name="type" Type="Microsoft.NAV.contactType" />
<Property Name="displayName" Type="Edm.String" Nullable="false" MaxLength="100" />
<Property Name="jobTitle" Type="Edm.String" Nullable="false" MaxLength="30" />
<Property Name="companyNumber" Type="Edm.String" MaxLength="20" />
<Property Name="companyName" Type="Edm.String" MaxLength="100" />
<Property Name="contactBusinessRelation" Type="Microsoft.NAV.contactBusinessRelation" />
<Property Name="addressLine1" Type="Edm.String" MaxLength="100" />
<Property Name="addressLine2" Type="Edm.String" MaxLength="50" />
<Property Name="city" Type="Edm.String" MaxLength="30" />
<Property Name="state" Type="Edm.String" MaxLength="30" />
<Property Name="country" Type="Edm.String" MaxLength="10" />
<Property Name="postalCode" Type="Edm.String" MaxLength="20" />
<Property Name="phoneNumber" Type="Edm.String" MaxLength="30" />
<Property Name="mobilePhoneNumber" Type="Edm.String" MaxLength="30" />
<Property Name="email" Type="Edm.String" MaxLength="80" />
<Property Name="website" Type="Edm.String" MaxLength="80" />
<Property Name="searchName" Type="Edm.String" MaxLength="100" />
<Property Name="privacyBlocked" Type="Edm.Boolean" />
<Property Name="taxRegistrationNumber" Type="Edm.String" />
<Property Name="lastInteractionDate" Type="Edm.Date" />
<Property Name="lastModifiedDateTime" Type="Edm.DateTimeOffset" />
<NavigationProperty Name="contactInformation" Type="Microsoft.NAV.contactInformation" Partner="contact" ContainsTarget="true">
<ReferentialConstraint Property="id" ReferencedProperty="contactId" />
</NavigationProperty>
<NavigationProperty Name="picture" Type="Microsoft.NAV.picture" Partner="contact" ContainsTarget="true">
<ReferentialConstraint Property="id" ReferencedProperty="id" />
</NavigationProperty>
</EntityType>
![]()
![Click and drag to move]()