SQL Server / Creatio API / $expand parameter
Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
-- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
DECLARE @queryParams int
-- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @queryParams OUT
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, '$expand', 'Collection2'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'ForceUseSession', 'true'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'BPMCSRF', '{{BPMCSRF}}'
DECLARE @resp int
EXEC sp_OAMethod @http, 'QuickRequestParams', @resp OUT, 'GET', 'https://myserver.com/0/ServiceModel/EntityDataService.svc/Collection1Collection(guid''Id'')', @queryParams
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
RETURN
END
DECLARE @sbResponseBody int
-- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
EXEC @hr = sp_OADestroy @resp
DECLARE @xmlResponse int
-- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xmlResponse OUT
EXEC sp_OAMethod @xmlResponse, 'LoadSb', @success OUT, @sbResponseBody, 1
EXEC sp_OAMethod @xmlResponse, 'GetXml', @sTmp0 OUT
PRINT @sTmp0
-- Sample XML response:
-- (Sample code for parsing the XML response is shown below)
-- <?xml version="1.0" encoding="utf-8"?>
-- <entry xml:base="https://myserver.com/0/ServiceModel/EntityDataService.svc/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
-- <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')</id>
-- <category term="Terrasoft.Configuration.Employee" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"/>
-- <link rel="edit" title="Employee" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy" type="application/atom+xml;type=entry" title="CreatedBy" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/CreatedBy"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy" type="application/atom+xml;type=entry" title="ModifiedBy" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/ModifiedBy"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Contact" type="application/atom+xml;type=entry" title="Contact" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Contact"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnitCollectionByHead" type="application/atom+xml;type=feed" title="OrgStructureUnitCollectionByHead" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/OrgStructureUnitCollectionByHead"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnit" type="application/atom+xml;type=entry" title="OrgStructureUnit" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/OrgStructureUnit"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Job" type="application/atom+xml;type=entry" title="Job" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Job"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Owner" type="application/atom+xml;type=entry" title="Owner" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Owner"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ReasonForDismissal" type="application/atom+xml;type=entry" title="ReasonForDismissal" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/ReasonForDismissal"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Account" type="application/atom+xml;type=entry" title="Account" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Account">
-- <m:inline>
-- <entry>
-- <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')</id>
-- <category term="Terrasoft.Configuration.Account" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"/>
-- <link rel="edit" title="Account" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountLogo" type="application/atom+xml;type=entry" title="AccountLogo" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountLogo"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Owner" type="application/atom+xml;type=entry" title="Owner" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Owner"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy" type="application/atom+xml;type=entry" title="CreatedBy" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CreatedBy"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy" type="application/atom+xml;type=entry" title="ModifiedBy" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ModifiedBy"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Ownership" type="application/atom+xml;type=entry" title="Ownership" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Ownership"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/PrimaryContact" type="application/atom+xml;type=entry" title="PrimaryContact" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/PrimaryContact"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Parent" type="application/atom+xml;type=entry" title="Parent" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Parent"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountCollectionByParent" type="application/atom+xml;type=feed" title="AccountCollectionByParent" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountCollectionByParent"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Industry" type="application/atom+xml;type=entry" title="Industry" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Industry"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Type" type="application/atom+xml;type=entry" title="Type" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Type"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AddressType" type="application/atom+xml;type=entry" title="AddressType" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AddressType"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/City" type="application/atom+xml;type=entry" title="City" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/City"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Region" type="application/atom+xml;type=entry" title="Region" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Region"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Country" type="application/atom+xml;type=entry" title="Country" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Country"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountCategory" type="application/atom+xml;type=entry" title="AccountCategory" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountCategory"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeesNumber" type="application/atom+xml;type=entry" title="EmployeesNumber" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EmployeesNumber"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AnnualRevenue" type="application/atom+xml;type=entry" title="AnnualRevenue" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AnnualRevenue"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/PriceList" type="application/atom+xml;type=entry" title="PriceList" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/PriceList"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContactCollectionByAccount" type="application/atom+xml;type=feed" title="ContactCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ContactCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SysAdminUnitCollectionByAccount" type="application/atom+xml;type=feed" title="SysAdminUnitCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/SysAdminUnitCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SysAdminUnitCollectionByPortalAccount" type="application/atom+xml;type=feed" title="SysAdminUnitCollectionByPortalAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/SysAdminUnitCollectionByPortalAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountAddressCollectionByAccount" type="application/atom+xml;type=feed" title="AccountAddressCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountAddressCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountAlternativeNameCollectionByAccount" type="application/atom+xml;type=feed" title="AccountAlternativeNameCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountAlternativeNameCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountAnniversaryCollectionByAccount" type="application/atom+xml;type=feed" title="AccountAnniversaryCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountAnniversaryCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountBillingInfoCollectionByAccount" type="application/atom+xml;type=feed" title="AccountBillingInfoCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountBillingInfoCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountCommunicationCollectionByAccount" type="application/atom+xml;type=feed" title="AccountCommunicationCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountCommunicationCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountDuplicateCollectionByEntity1" type="application/atom+xml;type=feed" title="AccountDuplicateCollectionByEntity1" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountDuplicateCollectionByEntity1"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountDuplicateCollectionByEntity2" type="application/atom+xml;type=feed" title="AccountDuplicateCollectionByEntity2" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountDuplicateCollectionByEntity2"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountEnrichedDataCollectionByAccount" type="application/atom+xml;type=feed" title="AccountEnrichedDataCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountEnrichedDataCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountFileCollectionByAccount" type="application/atom+xml;type=feed" title="AccountFileCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountFileCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountForecastCollectionByAccount" type="application/atom+xml;type=feed" title="AccountForecastCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountForecastCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountInFolderCollectionByAccount" type="application/atom+xml;type=feed" title="AccountInFolderCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountInFolderCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountInTagCollectionByEntity" type="application/atom+xml;type=feed" title="AccountInTagCollectionByEntity" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountInTagCollectionByEntity"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountOrganizationChartCollectionByAccount" type="application/atom+xml;type=feed" title="AccountOrganizationChartCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountOrganizationChartCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ActivityCollectionByAccount" type="application/atom+xml;type=feed" title="ActivityCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ActivityCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CaseCollectionByAccount" type="application/atom+xml;type=feed" title="CaseCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CaseCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ServicePactCollectionByServiceProvider" type="application/atom+xml;type=feed" title="ServicePactCollectionByServiceProvider" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ServicePactCollectionByServiceProvider"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LeadCollectionByQualifiedAccount" type="application/atom+xml;type=feed" title="LeadCollectionByQualifiedAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/LeadCollectionByQualifiedAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCollectionByAccount" type="application/atom+xml;type=feed" title="OpportunityCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCollectionByPartner" type="application/atom+xml;type=feed" title="OpportunityCollectionByPartner" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCollectionByPartner"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCollectionByWinner" type="application/atom+xml;type=feed" title="OpportunityCollectionByWinner" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCollectionByWinner"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LeadCollectionByPartner" type="application/atom+xml;type=feed" title="LeadCollectionByPartner" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/LeadCollectionByPartner"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrderCollectionByAccount" type="application/atom+xml;type=feed" title="OrderCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OrderCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwQueueItemCollectionByAccount" type="application/atom+xml;type=feed" title="VwQueueItemCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwQueueItemCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/InvoiceCollectionByAccount" type="application/atom+xml;type=feed" title="InvoiceCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/InvoiceCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/InvoiceCollectionBySupplier" type="application/atom+xml;type=feed" title="InvoiceCollectionBySupplier" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/InvoiceCollectionBySupplier"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContractCollectionByAccount" type="application/atom+xml;type=feed" title="ContractCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ContractCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContractCollectionByOurCompany" type="application/atom+xml;type=feed" title="ContractCollectionByOurCompany" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ContractCollectionByOurCompany"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ProjectCollectionByAccount" type="application/atom+xml;type=feed" title="ProjectCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ProjectCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ProjectCollectionBySupplier" type="application/atom+xml;type=feed" title="ProjectCollectionBySupplier" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ProjectCollectionBySupplier"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/DocumentCollectionByAccount" type="application/atom+xml;type=feed" title="DocumentCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/DocumentCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CallCollectionByAccount" type="application/atom+xml;type=feed" title="CallCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CallCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CompetitorProductCollectionByCompetitor" type="application/atom+xml;type=feed" title="CompetitorProductCollectionByCompetitor" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CompetitorProductCollectionByCompetitor"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConfItemUserCollectionByAccount" type="application/atom+xml;type=feed" title="ConfItemUserCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ConfItemUserCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContactCareerCollectionByAccount" type="application/atom+xml;type=feed" title="ContactCareerCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ContactCareerCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CTISearchResultCollectionByAccount" type="application/atom+xml;type=feed" title="CTISearchResultCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CTISearchResultCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmailFolderColumnValuesSettingCollectionByAccount" type="application/atom+xml;type=feed" title="EmailFolderColumnValuesSettingCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EmailFolderColumnValuesSettingCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCollectionByAccount" type="application/atom+xml;type=feed" title="EmployeeCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EmployeeCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCareerCollectionByAccount" type="application/atom+xml;type=feed" title="EmployeeCareerCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EmployeeCareerCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EnrchFoundAccountCollectionByAccount" type="application/atom+xml;type=feed" title="EnrchFoundAccountCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EnrchFoundAccountCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EventTeamCollectionByAccount" type="application/atom+xml;type=feed" title="EventTeamCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EventTeamCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/PartnershipCollectionByAccount" type="application/atom+xml;type=feed" title="PartnershipCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/PartnershipCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LeadQualificationCollectionByAccount" type="application/atom+xml;type=feed" title="LeadQualificationCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/LeadQualificationCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/MktgActivityCollectionByAccount" type="application/atom+xml;type=feed" title="MktgActivityCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/MktgActivityCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCompetitorCollectionByCompetitor" type="application/atom+xml;type=feed" title="OpportunityCompetitorCollectionByCompetitor" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCompetitorCollectionByCompetitor"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCompetitorCollectionBySupplier" type="application/atom+xml;type=feed" title="OpportunityCompetitorCollectionBySupplier" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCompetitorCollectionBySupplier"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityParticipantCollectionByAccount" type="application/atom+xml;type=feed" title="OpportunityParticipantCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityParticipantCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/QuickDialUserSettingsCollectionByAccount" type="application/atom+xml;type=feed" title="QuickDialUserSettingsCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/QuickDialUserSettingsCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/RelationshipCollectionByAccountA" type="application/atom+xml;type=feed" title="RelationshipCollectionByAccountA" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/RelationshipCollectionByAccountA"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/RelationshipCollectionByAccountB" type="application/atom+xml;type=feed" title="RelationshipCollectionByAccountB" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/RelationshipCollectionByAccountB"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ServiceObjectCollectionByAccount" type="application/atom+xml;type=feed" title="ServiceObjectCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ServiceObjectCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwSysAdminUnitCollectionByAccount" type="application/atom+xml;type=feed" title="VwSysAdminUnitCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwSysAdminUnitCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountDuplicateCollectionByEntity1" type="application/atom+xml;type=feed" title="VwAccountDuplicateCollectionByEntity1" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountDuplicateCollectionByEntity1"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountDuplicateCollectionByEntity2" type="application/atom+xml;type=feed" title="VwAccountDuplicateCollectionByEntity2" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountDuplicateCollectionByEntity2"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountModuleHistoryCollectionByAccount" type="application/atom+xml;type=feed" title="VwAccountModuleHistoryCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountModuleHistoryCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountRelationshipCollectionByAccount" type="application/atom+xml;type=feed" title="VwAccountRelationshipCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountRelationshipCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountRelationshipCollectionByRelatedAccount" type="application/atom+xml;type=feed" title="VwAccountRelationshipCollectionByRelatedAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountRelationshipCollectionByRelatedAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAnniversaryCollectionByAccount" type="application/atom+xml;type=feed" title="VwAnniversaryCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAnniversaryCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwContactRelationshipCollectionByRelatedAccount" type="application/atom+xml;type=feed" title="VwContactRelationshipCollectionByRelatedAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwContactRelationshipCollectionByRelatedAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwGroupSysAdminUnitCollectionByAccount" type="application/atom+xml;type=feed" title="VwGroupSysAdminUnitCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwGroupSysAdminUnitCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwGroupSysAdminUnitCollectionByPortalAccount" type="application/atom+xml;type=feed" title="VwGroupSysAdminUnitCollectionByPortalAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwGroupSysAdminUnitCollectionByPortalAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwModuleHistoryCollectionByAccount" type="application/atom+xml;type=feed" title="VwModuleHistoryCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwModuleHistoryCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwPortalOpportunityCollectionByAccount" type="application/atom+xml;type=feed" title="VwPortalOpportunityCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwPortalOpportunityCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwPortalOpportunityCollectionByPartner" type="application/atom+xml;type=feed" title="VwPortalOpportunityCollectionByPartner" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwPortalOpportunityCollectionByPartner"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwProjectHierarchyCollectionByAccount" type="application/atom+xml;type=feed" title="VwProjectHierarchyCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwProjectHierarchyCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwRelationshipCollectionByAccountA" type="application/atom+xml;type=feed" title="VwRelationshipCollectionByAccountA" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwRelationshipCollectionByAccountA"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwRelationshipCollectionByAccountB" type="application/atom+xml;type=feed" title="VwRelationshipCollectionByAccountB" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwRelationshipCollectionByAccountB"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwServiceRecepientsCollectionByAccount" type="application/atom+xml;type=feed" title="VwServiceRecepientsCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwServiceRecepientsCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwSspAdminUnitCollectionByAccount" type="application/atom+xml;type=feed" title="VwSspAdminUnitCollectionByAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwSspAdminUnitCollectionByAccount"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwSspAdminUnitCollectionByPortalAccount" type="application/atom+xml;type=feed" title="VwSspAdminUnitCollectionByPortalAccount" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwSspAdminUnitCollectionByPortalAccount"/>
-- <title/>
-- <updated>2020-04-09T11:22:10Z</updated>
-- <author>
-- <name/>
-- </author>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/edit-media/Logo" type="application/octet-stream" title="Logo" href="AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Logo"/>
-- <content type="application/xml">
-- <m:properties>
-- <d:Id m:type="Edm.Guid">a0bf3e92-f36b-1410-0499-00155d043204</d:Id>
-- <d:Name>XT Group</d:Name>
-- <d:AccountLogoId m:type="Edm.Guid">69517c67-e5de-47db-ae50-df69447a12cf</d:AccountLogoId>
-- <d:OwnerId m:type="Edm.Guid">cad50d15-f28d-49fc-aa79-21615ac35b86</d:OwnerId>
-- <d:CreatedOn m:type="Edm.DateTime">2020-01-27T08:00:14Z</d:CreatedOn>
-- <d:CreatedById m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:CreatedById>
-- <d:ModifiedOn m:type="Edm.DateTime">2020-01-10T10:12:35Z</d:ModifiedOn>
-- <d:ModifiedById m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:ModifiedById>
-- <d:ProcessListeners m:type="Edm.Int32">0</d:ProcessListeners>
-- <d:OwnershipId m:type="Edm.Guid">e0ae3e02-f46b-1410-fb98-00155d043204</d:OwnershipId>
-- <d:PrimaryContactId m:type="Edm.Guid">017df77c-b01c-4554-b7eb-760ac91cd0d7</d:PrimaryContactId>
-- <d:ParentId m:type="Edm.Guid">00000000-0000-0000-0000-000000000000</d:ParentId>
-- <d:IndustryId m:type="Edm.Guid">bd7f1e4a-f36b-1410-c493-00155d043205</d:IndustryId>
-- <d:Code>60</d:Code>
-- <d:TypeId m:type="Edm.Guid">03a75490-53e6-df11-971b-001d60e938c6</d:TypeId>
-- <d:Phone>+1 212 753 2819</d:Phone>
-- <d:AdditionalPhone>+1 212 753 2845</d:AdditionalPhone>
-- <d:Fax/>
-- <d:Web>www.xtg.com</d:Web>
-- <d:AddressTypeId m:type="Edm.Guid">780bf68c-4b6e-df11-b988-001d60e938c6</d:AddressTypeId>
-- <d:Address>17 Road Street</d:Address>
-- <d:CityId m:type="Edm.Guid">c0af42ea-f36b-1410-0299-00155d043204</d:CityId>
-- <d:RegionId m:type="Edm.Guid">00b03270-f36b-1410-fd98-00155d043204</d:RegionId>
-- <d:Zip>10351</d:Zip>
-- <d:CountryId m:type="Edm.Guid">e0be1264-f36b-1410-fa98-00155d043204</d:CountryId>
-- <d:AccountCategoryId m:type="Edm.Guid">37ea507c-55e6-df11-971b-001d60e938c6</d:AccountCategoryId>
-- <d:EmployeesNumberId m:type="Edm.Guid">2c344115-55e6-df11-971b-001d60e938c6</d:EmployeesNumberId>
-- <d:AnnualRevenueId m:type="Edm.Guid">498aceb9-55e6-df11-971b-001d60e938c6</d:AnnualRevenueId>
-- <d:Notes/>
-- <d:AlternativeName/>
-- <d:GPSN>42.6558932018082</d:GPSN>
-- <d:GPSE>-73.7562183364144</d:GPSE>
-- <d:Completeness m:type="Edm.Int32">100</d:Completeness>
-- <d:PriceListId m:type="Edm.Guid">00000000-0000-0000-0000-000000000000</d:PriceListId>
-- </m:properties>
-- </content>
-- </entry>
-- </m:inline>
-- </link>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Manager" type="application/atom+xml;type=entry" title="Manager" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Manager"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCollectionByManager" type="application/atom+xml;type=feed" title="EmployeeCollectionByManager" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeCollectionByManager"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCareerCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeCareerCollectionByEmployee" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeCareerCollectionByEmployee"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeFileCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeFileCollectionByEmployee" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeFileCollectionByEmployee"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInFolderCollectionByEmployee" type="application/atom+xml;type=feed" title="EmployeeInFolderCollectionByEmployee" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeInFolderCollectionByEmployee"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInTagCollectionByEntity" type="application/atom+xml;type=feed" title="EmployeeInTagCollectionByEntity" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeInTagCollectionByEntity"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SalaryCollectionByEmployee" type="application/atom+xml;type=feed" title="SalaryCollectionByEmployee" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/SalaryCollectionByEmployee"/>
-- <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwEmployeesHierarchyCollectionByEmployee" type="application/atom+xml;type=feed" title="VwEmployeesHierarchyCollectionByEmployee" href="EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/VwEmployeesHierarchyCollectionByEmployee"/>
-- <title/>
-- <updated>2020-04-09T11:22:10Z</updated>
-- <author>
-- <name/>
-- </author>
-- <content type="application/xml">
-- <m:properties>
-- <d:Id m:type="Edm.Guid">c31c7862-fe33-4a13-9bbc-0943fa08fd02</d:Id>
-- <d:Name>William Walker</d:Name>
-- <d:CreatedOn m:type="Edm.DateTime">2017-03-30T14:50:04Z</d:CreatedOn>
-- <d:CreatedById m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:CreatedById>
-- <d:ModifiedOn m:type="Edm.DateTime">2020-02-14T06:30:46.234Z</d:ModifiedOn>
-- <d:ModifiedById m:type="Edm.Guid">410006e1-ca4e-4502-a9ec-e54d922d2c00</d:ModifiedById>
-- <d:ProcessListeners m:type="Edm.Int32">0</d:ProcessListeners>
-- <d:ContactId m:type="Edm.Guid">227aab3b-7c0c-4181-abf9-81585563ab23</d:ContactId>
-- <d:OrgStructureUnitId m:type="Edm.Guid">d436a9ce-9690-4415-9e03-e8061d7cabb5</d:OrgStructureUnitId>
-- <d:Notes/>
-- <d:JobId m:type="Edm.Guid">11d68189-ced6-df11-9b2a-001d60e938c6</d:JobId>
-- <d:FullJobTitle>Developer</d:FullJobTitle>
-- <d:OwnerId m:type="Edm.Guid">76929f8c-7e15-4c64-bdb0-adc62d383727</d:OwnerId>
-- <d:CareerStartDate m:type="Edm.DateTime">2019-09-08T00:00:00</d:CareerStartDate>
-- <d:CareerDueDate m:type="Edm.DateTime">0001-01-01T00:00:00</d:CareerDueDate>
-- <d:ProbationDueDate m:type="Edm.DateTime">2020-01-09T00:00:00</d:ProbationDueDate>
-- <d:ReasonForDismissalId m:type="Edm.Guid">00000000-0000-0000-0000-000000000000</d:ReasonForDismissalId>
-- <d:AccountId m:type="Edm.Guid">a0bf3e92-f36b-1410-0499-00155d043204</d:AccountId>
-- <d:ManagerId m:type="Edm.Guid">3e5bd47e-1ebd-41db-a9a6-a3560dcee3cb</d:ManagerId>
-- </m:properties>
-- </content>
-- </entry>
-- Sample code for parsing the XML response...
-- Use this online tool to generate parsing code from sample XML: Generate XML Parsing Code
DECLARE @link_rel nvarchar(4000)
DECLARE @link_title nvarchar(4000)
DECLARE @link_href nvarchar(4000)
DECLARE @link_type nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @updated nvarchar(4000)
DECLARE @content_type nvarchar(4000)
DECLARE @d_Id_m_type nvarchar(4000)
DECLARE @d_Id nvarchar(4000)
DECLARE @d_Name nvarchar(4000)
DECLARE @d_AccountLogoId_m_type nvarchar(4000)
DECLARE @d_AccountLogoId nvarchar(4000)
DECLARE @d_OwnerId_m_type nvarchar(4000)
DECLARE @d_OwnerId nvarchar(4000)
DECLARE @d_CreatedOn_m_type nvarchar(4000)
DECLARE @d_CreatedOn nvarchar(4000)
DECLARE @d_CreatedById_m_type nvarchar(4000)
DECLARE @d_CreatedById nvarchar(4000)
DECLARE @d_ModifiedOn_m_type nvarchar(4000)
DECLARE @d_ModifiedOn nvarchar(4000)
DECLARE @d_ModifiedById_m_type nvarchar(4000)
DECLARE @d_ModifiedById nvarchar(4000)
DECLARE @d_ProcessListeners_m_type nvarchar(4000)
DECLARE @d_ProcessListeners int
DECLARE @d_OwnershipId_m_type nvarchar(4000)
DECLARE @d_OwnershipId nvarchar(4000)
DECLARE @d_PrimaryContactId_m_type nvarchar(4000)
DECLARE @d_PrimaryContactId nvarchar(4000)
DECLARE @d_ParentId_m_type nvarchar(4000)
DECLARE @d_ParentId nvarchar(4000)
DECLARE @d_IndustryId_m_type nvarchar(4000)
DECLARE @d_IndustryId nvarchar(4000)
DECLARE @d_Code int
DECLARE @d_TypeId_m_type nvarchar(4000)
DECLARE @d_TypeId nvarchar(4000)
DECLARE @d_Phone nvarchar(4000)
DECLARE @d_AdditionalPhone nvarchar(4000)
DECLARE @d_Web nvarchar(4000)
DECLARE @d_AddressTypeId_m_type nvarchar(4000)
DECLARE @d_AddressTypeId nvarchar(4000)
DECLARE @d_Address nvarchar(4000)
DECLARE @d_CityId_m_type nvarchar(4000)
DECLARE @d_CityId nvarchar(4000)
DECLARE @d_RegionId_m_type nvarchar(4000)
DECLARE @d_RegionId nvarchar(4000)
DECLARE @d_Zip int
DECLARE @d_CountryId_m_type nvarchar(4000)
DECLARE @d_CountryId nvarchar(4000)
DECLARE @d_AccountCategoryId_m_type nvarchar(4000)
DECLARE @d_AccountCategoryId nvarchar(4000)
DECLARE @d_EmployeesNumberId_m_type nvarchar(4000)
DECLARE @d_EmployeesNumberId nvarchar(4000)
DECLARE @d_AnnualRevenueId_m_type nvarchar(4000)
DECLARE @d_AnnualRevenueId nvarchar(4000)
DECLARE @d_GPSN nvarchar(4000)
DECLARE @d_GPSE nvarchar(4000)
DECLARE @d_Completeness_m_type nvarchar(4000)
DECLARE @d_Completeness int
DECLARE @d_PriceListId_m_type nvarchar(4000)
DECLARE @d_PriceListId nvarchar(4000)
DECLARE @entry_xml_base nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetAttrValue', @entry_xml_base OUT, 'xml:base'
DECLARE @entry_xmlns nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetAttrValue', @entry_xmlns OUT, 'xmlns'
DECLARE @entry_xmlns_d nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetAttrValue', @entry_xmlns_d OUT, 'xmlns:d'
DECLARE @entry_xmlns_m nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetAttrValue', @entry_xmlns_m OUT, 'xmlns:m'
DECLARE @entry_xmlns_georss nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetAttrValue', @entry_xmlns_georss OUT, 'xmlns:georss'
DECLARE @entry_xmlns_gml nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetAttrValue', @entry_xmlns_gml OUT, 'xmlns:gml'
DECLARE @id nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @id OUT, 'id'
DECLARE @category_term nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @category_term OUT, 'category|(term)'
DECLARE @category_scheme nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @category_scheme OUT, 'category|(scheme)'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @xmlResponse, 'NumChildrenHavingTag', @count_i OUT, 'link'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @xmlResponse, 'I', @i
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @link_rel OUT, 'link[i]|(rel)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @link_title OUT, 'link[i]|(title)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @link_href OUT, 'link[i]|(href)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @link_type OUT, 'link[i]|(type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @id OUT, 'link[i]|m:inline|entry|id'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @category_term OUT, 'link[i]|m:inline|entry|category|(term)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @category_scheme OUT, 'link[i]|m:inline|entry|category|(scheme)'
SELECT @j = 0
EXEC sp_OAMethod @xmlResponse, 'NumChildrenHavingTag', @count_j OUT, 'link[i]|m:inline|entry|link'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @xmlResponse, 'J', @j
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @link_rel OUT, 'link[i]|m:inline|entry|link[j]|(rel)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @link_title OUT, 'link[i]|m:inline|entry|link[j]|(title)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @link_href OUT, 'link[i]|m:inline|entry|link[j]|(href)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @link_type OUT, 'link[i]|m:inline|entry|link[j]|(type)'
SELECT @j = @j + 1
END
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @updated OUT, 'link[i]|m:inline|entry|updated'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @content_type OUT, 'link[i]|m:inline|entry|content|(type)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_Id_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:Id|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Id OUT, 'link[i]|m:inline|entry|content|m:properties|d:Id'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Name OUT, 'link[i]|m:inline|entry|content|m:properties|d:Name'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AccountLogoId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:AccountLogoId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AccountLogoId OUT, 'link[i]|m:inline|entry|content|m:properties|d:AccountLogoId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_OwnerId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:OwnerId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_OwnerId OUT, 'link[i]|m:inline|entry|content|m:properties|d:OwnerId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CreatedOn_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:CreatedOn|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CreatedOn OUT, 'link[i]|m:inline|entry|content|m:properties|d:CreatedOn'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CreatedById_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:CreatedById|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CreatedById OUT, 'link[i]|m:inline|entry|content|m:properties|d:CreatedById'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ModifiedOn_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:ModifiedOn|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ModifiedOn OUT, 'link[i]|m:inline|entry|content|m:properties|d:ModifiedOn'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ModifiedById_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:ModifiedById|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ModifiedById OUT, 'link[i]|m:inline|entry|content|m:properties|d:ModifiedById'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ProcessListeners_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:ProcessListeners|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_ProcessListeners OUT, 'link[i]|m:inline|entry|content|m:properties|d:ProcessListeners'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_OwnershipId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:OwnershipId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_OwnershipId OUT, 'link[i]|m:inline|entry|content|m:properties|d:OwnershipId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_PrimaryContactId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:PrimaryContactId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_PrimaryContactId OUT, 'link[i]|m:inline|entry|content|m:properties|d:PrimaryContactId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ParentId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:ParentId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ParentId OUT, 'link[i]|m:inline|entry|content|m:properties|d:ParentId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_IndustryId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:IndustryId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_IndustryId OUT, 'link[i]|m:inline|entry|content|m:properties|d:IndustryId'
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_Code OUT, 'link[i]|m:inline|entry|content|m:properties|d:Code'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_TypeId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:TypeId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_TypeId OUT, 'link[i]|m:inline|entry|content|m:properties|d:TypeId'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Phone OUT, 'link[i]|m:inline|entry|content|m:properties|d:Phone'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AdditionalPhone OUT, 'link[i]|m:inline|entry|content|m:properties|d:AdditionalPhone'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Web OUT, 'link[i]|m:inline|entry|content|m:properties|d:Web'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AddressTypeId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:AddressTypeId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AddressTypeId OUT, 'link[i]|m:inline|entry|content|m:properties|d:AddressTypeId'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Address OUT, 'link[i]|m:inline|entry|content|m:properties|d:Address'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CityId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:CityId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CityId OUT, 'link[i]|m:inline|entry|content|m:properties|d:CityId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_RegionId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:RegionId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_RegionId OUT, 'link[i]|m:inline|entry|content|m:properties|d:RegionId'
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_Zip OUT, 'link[i]|m:inline|entry|content|m:properties|d:Zip'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CountryId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:CountryId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CountryId OUT, 'link[i]|m:inline|entry|content|m:properties|d:CountryId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AccountCategoryId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:AccountCategoryId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AccountCategoryId OUT, 'link[i]|m:inline|entry|content|m:properties|d:AccountCategoryId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_EmployeesNumberId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:EmployeesNumberId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_EmployeesNumberId OUT, 'link[i]|m:inline|entry|content|m:properties|d:EmployeesNumberId'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AnnualRevenueId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:AnnualRevenueId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AnnualRevenueId OUT, 'link[i]|m:inline|entry|content|m:properties|d:AnnualRevenueId'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_GPSN OUT, 'link[i]|m:inline|entry|content|m:properties|d:GPSN'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_GPSE OUT, 'link[i]|m:inline|entry|content|m:properties|d:GPSE'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_Completeness_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:Completeness|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_Completeness OUT, 'link[i]|m:inline|entry|content|m:properties|d:Completeness'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_PriceListId_m_type OUT, 'link[i]|m:inline|entry|content|m:properties|d:PriceListId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_PriceListId OUT, 'link[i]|m:inline|entry|content|m:properties|d:PriceListId'
SELECT @i = @i + 1
END
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @updated OUT, 'updated'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @content_type OUT, 'content|(type)'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_Id_m_type OUT, 'content|m:properties|d:Id|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Id OUT, 'content|m:properties|d:Id'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Name OUT, 'content|m:properties|d:Name'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CreatedOn_m_type OUT, 'content|m:properties|d:CreatedOn|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CreatedOn OUT, 'content|m:properties|d:CreatedOn'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CreatedById_m_type OUT, 'content|m:properties|d:CreatedById|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CreatedById OUT, 'content|m:properties|d:CreatedById'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ModifiedOn_m_type OUT, 'content|m:properties|d:ModifiedOn|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ModifiedOn OUT, 'content|m:properties|d:ModifiedOn'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ModifiedById_m_type OUT, 'content|m:properties|d:ModifiedById|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ModifiedById OUT, 'content|m:properties|d:ModifiedById'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ProcessListeners_m_type OUT, 'content|m:properties|d:ProcessListeners|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_ProcessListeners OUT, 'content|m:properties|d:ProcessListeners'
DECLARE @d_ContactId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ContactId_m_type OUT, 'content|m:properties|d:ContactId|(m:type)'
DECLARE @d_ContactId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ContactId OUT, 'content|m:properties|d:ContactId'
DECLARE @d_OrgStructureUnitId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_OrgStructureUnitId_m_type OUT, 'content|m:properties|d:OrgStructureUnitId|(m:type)'
DECLARE @d_OrgStructureUnitId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_OrgStructureUnitId OUT, 'content|m:properties|d:OrgStructureUnitId'
DECLARE @d_JobId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_JobId_m_type OUT, 'content|m:properties|d:JobId|(m:type)'
DECLARE @d_JobId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_JobId OUT, 'content|m:properties|d:JobId'
DECLARE @d_FullJobTitle nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_FullJobTitle OUT, 'content|m:properties|d:FullJobTitle'
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_OwnerId_m_type OUT, 'content|m:properties|d:OwnerId|(m:type)'
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_OwnerId OUT, 'content|m:properties|d:OwnerId'
DECLARE @d_CareerStartDate_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CareerStartDate_m_type OUT, 'content|m:properties|d:CareerStartDate|(m:type)'
DECLARE @d_CareerStartDate nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CareerStartDate OUT, 'content|m:properties|d:CareerStartDate'
DECLARE @d_CareerDueDate_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CareerDueDate_m_type OUT, 'content|m:properties|d:CareerDueDate|(m:type)'
DECLARE @d_CareerDueDate nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CareerDueDate OUT, 'content|m:properties|d:CareerDueDate'
DECLARE @d_ProbationDueDate_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ProbationDueDate_m_type OUT, 'content|m:properties|d:ProbationDueDate|(m:type)'
DECLARE @d_ProbationDueDate nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ProbationDueDate OUT, 'content|m:properties|d:ProbationDueDate'
DECLARE @d_ReasonForDismissalId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ReasonForDismissalId_m_type OUT, 'content|m:properties|d:ReasonForDismissalId|(m:type)'
DECLARE @d_ReasonForDismissalId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ReasonForDismissalId OUT, 'content|m:properties|d:ReasonForDismissalId'
DECLARE @d_AccountId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AccountId_m_type OUT, 'content|m:properties|d:AccountId|(m:type)'
DECLARE @d_AccountId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AccountId OUT, 'content|m:properties|d:AccountId'
DECLARE @d_ManagerId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ManagerId_m_type OUT, 'content|m:properties|d:ManagerId|(m:type)'
DECLARE @d_ManagerId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ManagerId OUT, 'content|m:properties|d:ManagerId'
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @xmlResponse
END
GO
Curl Command
curl -G -d "$expand=Collection2"
-H "ForceUseSession: true"
-H "BPMCSRF: {{BPMCSRF}}"
https://myserver.com/0/ServiceModel/EntityDataService.svc/Collection1Collection(guid'Id')
Postman Collection Item JSON
{
"name": "$expand parameter",
"request": {
"method": "GET",
"header": [
{
"key": "ForceUseSession",
"type": "text",
"value": "true"
},
{
"key": "BPMCSRF",
"type": "text",
"value": "{{BPMCSRF}}"
}
],
"url": {
"raw": "{{BaseURI}}/0/ServiceModel/EntityDataService.svc/{{CollectionName1}}Collection(guid'{{ObjectId1}}')?$expand={{CollectionName2}} ",
"host": [
"{{BaseURI}}"
],
"path": [
"0",
"ServiceModel",
"EntityDataService.svc",
"{{CollectionName1}}Collection(guid'{{ObjectId1}}')"
],
"query": [
{
"key": "$expand",
"value": "{{CollectionName2}} "
}
]
},
"description": "Request for getting an object collection instance by instance Id of another object collection via the [$expand](https://www.odata.org/documentation/odata-version-3-0/odata-version-3-0-core-protocol/#theexpandsystemqueryoption) parameter."
},
"response": [
{
"name": "[200] Gets an objects collection instances by another object collection",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "ForceUseSession",
"type": "text",
"value": "true"
},
{
"key": "BPMCSRF",
"type": "text",
"value": "{{BPMCSRF}}"
}
],
"url": {
"raw": "https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')?$expand=Account",
"protocol": "https",
"host": [
"myserver",
"com"
],
"path": [
"0",
"ServiceModel",
"EntityDataService.svc",
"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')"
],
"query": [
{
"key": "$expand",
"value": "Account"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "xml",
"header": [
{
"key": "Cache-Control",
"value": "no-cache"
},
{
"key": "Content-Type",
"value": "application/atom+xml;type=entry;charset=utf-8"
},
{
"key": "Server",
"value": "Microsoft-IIS/10.0"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "DataServiceVersion",
"value": "3.0;"
},
{
"key": "X-AspNet-Version",
"value": "4.0.30319"
},
{
"key": "X-Powered-By",
"value": "ASP.NET"
},
{
"key": "X-Frame-Options",
"value": "SAMEORIGIN"
},
{
"key": "Date",
"value": "Thu, 09 Apr 2020 11:22:10 GMT"
},
{
"key": "Content-Length",
"value": "34821"
}
],
"cookie": [
],
"body": "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<entry xml:base=\"https://myserver.com/0/ServiceModel/EntityDataService.svc/\" xmlns=\"http://www.w3.org/2005/Atom\" xmlns:d=\"http://schemas.microsoft.com/ado/2007/08/dataservices\" xmlns:m=\"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata\" xmlns:georss=\"http://www.georss.org/georss\" xmlns:gml=\"http://www.opengis.net/gml\">\n <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')</id>\n <category term=\"Terrasoft.Configuration.Employee\" scheme=\"http://schemas.microsoft.com/ado/2007/08/dataservices/scheme\" />\n <link rel=\"edit\" title=\"Employee\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy\" type=\"application/atom+xml;type=entry\" title=\"CreatedBy\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/CreatedBy\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy\" type=\"application/atom+xml;type=entry\" title=\"ModifiedBy\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/ModifiedBy\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Contact\" type=\"application/atom+xml;type=entry\" title=\"Contact\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Contact\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnitCollectionByHead\" type=\"application/atom+xml;type=feed\" title=\"OrgStructureUnitCollectionByHead\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/OrgStructureUnitCollectionByHead\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrgStructureUnit\" type=\"application/atom+xml;type=entry\" title=\"OrgStructureUnit\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/OrgStructureUnit\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Job\" type=\"application/atom+xml;type=entry\" title=\"Job\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Job\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Owner\" type=\"application/atom+xml;type=entry\" title=\"Owner\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Owner\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ReasonForDismissal\" type=\"application/atom+xml;type=entry\" title=\"ReasonForDismissal\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/ReasonForDismissal\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Account\" type=\"application/atom+xml;type=entry\" title=\"Account\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Account\">\n <m:inline>\n <entry>\n <id>https://myserver.com/0/ServiceModel/EntityDataService.svc/AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')</id>\n <category term=\"Terrasoft.Configuration.Account\" scheme=\"http://schemas.microsoft.com/ado/2007/08/dataservices/scheme\" />\n <link rel=\"edit\" title=\"Account\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountLogo\" type=\"application/atom+xml;type=entry\" title=\"AccountLogo\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountLogo\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Owner\" type=\"application/atom+xml;type=entry\" title=\"Owner\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Owner\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy\" type=\"application/atom+xml;type=entry\" title=\"CreatedBy\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CreatedBy\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy\" type=\"application/atom+xml;type=entry\" title=\"ModifiedBy\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ModifiedBy\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Ownership\" type=\"application/atom+xml;type=entry\" title=\"Ownership\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Ownership\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/PrimaryContact\" type=\"application/atom+xml;type=entry\" title=\"PrimaryContact\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/PrimaryContact\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Parent\" type=\"application/atom+xml;type=entry\" title=\"Parent\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Parent\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountCollectionByParent\" type=\"application/atom+xml;type=feed\" title=\"AccountCollectionByParent\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountCollectionByParent\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Industry\" type=\"application/atom+xml;type=entry\" title=\"Industry\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Industry\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Type\" type=\"application/atom+xml;type=entry\" title=\"Type\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Type\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AddressType\" type=\"application/atom+xml;type=entry\" title=\"AddressType\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AddressType\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/City\" type=\"application/atom+xml;type=entry\" title=\"City\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/City\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Region\" type=\"application/atom+xml;type=entry\" title=\"Region\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Region\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Country\" type=\"application/atom+xml;type=entry\" title=\"Country\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Country\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountCategory\" type=\"application/atom+xml;type=entry\" title=\"AccountCategory\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountCategory\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeesNumber\" type=\"application/atom+xml;type=entry\" title=\"EmployeesNumber\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EmployeesNumber\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AnnualRevenue\" type=\"application/atom+xml;type=entry\" title=\"AnnualRevenue\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AnnualRevenue\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/PriceList\" type=\"application/atom+xml;type=entry\" title=\"PriceList\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/PriceList\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContactCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"ContactCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ContactCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/SysAdminUnitCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"SysAdminUnitCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/SysAdminUnitCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/SysAdminUnitCollectionByPortalAccount\" type=\"application/atom+xml;type=feed\" title=\"SysAdminUnitCollectionByPortalAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/SysAdminUnitCollectionByPortalAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountAddressCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountAddressCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountAddressCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountAlternativeNameCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountAlternativeNameCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountAlternativeNameCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountAnniversaryCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountAnniversaryCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountAnniversaryCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountBillingInfoCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountBillingInfoCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountBillingInfoCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountCommunicationCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountCommunicationCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountCommunicationCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountDuplicateCollectionByEntity1\" type=\"application/atom+xml;type=feed\" title=\"AccountDuplicateCollectionByEntity1\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountDuplicateCollectionByEntity1\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountDuplicateCollectionByEntity2\" type=\"application/atom+xml;type=feed\" title=\"AccountDuplicateCollectionByEntity2\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountDuplicateCollectionByEntity2\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountEnrichedDataCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountEnrichedDataCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountEnrichedDataCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountFileCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountFileCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountFileCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountForecastCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountForecastCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountForecastCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountInFolderCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountInFolderCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountInFolderCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountInTagCollectionByEntity\" type=\"application/atom+xml;type=feed\" title=\"AccountInTagCollectionByEntity\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountInTagCollectionByEntity\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountOrganizationChartCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"AccountOrganizationChartCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/AccountOrganizationChartCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ActivityCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"ActivityCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ActivityCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/CaseCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"CaseCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CaseCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ServicePactCollectionByServiceProvider\" type=\"application/atom+xml;type=feed\" title=\"ServicePactCollectionByServiceProvider\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ServicePactCollectionByServiceProvider\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/LeadCollectionByQualifiedAccount\" type=\"application/atom+xml;type=feed\" title=\"LeadCollectionByQualifiedAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/LeadCollectionByQualifiedAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"OpportunityCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCollectionByPartner\" type=\"application/atom+xml;type=feed\" title=\"OpportunityCollectionByPartner\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCollectionByPartner\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCollectionByWinner\" type=\"application/atom+xml;type=feed\" title=\"OpportunityCollectionByWinner\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCollectionByWinner\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/LeadCollectionByPartner\" type=\"application/atom+xml;type=feed\" title=\"LeadCollectionByPartner\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/LeadCollectionByPartner\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OrderCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"OrderCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OrderCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwQueueItemCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwQueueItemCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwQueueItemCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/InvoiceCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"InvoiceCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/InvoiceCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/InvoiceCollectionBySupplier\" type=\"application/atom+xml;type=feed\" title=\"InvoiceCollectionBySupplier\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/InvoiceCollectionBySupplier\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContractCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"ContractCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ContractCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContractCollectionByOurCompany\" type=\"application/atom+xml;type=feed\" title=\"ContractCollectionByOurCompany\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ContractCollectionByOurCompany\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ProjectCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"ProjectCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ProjectCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ProjectCollectionBySupplier\" type=\"application/atom+xml;type=feed\" title=\"ProjectCollectionBySupplier\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ProjectCollectionBySupplier\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/DocumentCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"DocumentCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/DocumentCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/CallCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"CallCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CallCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/CompetitorProductCollectionByCompetitor\" type=\"application/atom+xml;type=feed\" title=\"CompetitorProductCollectionByCompetitor\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CompetitorProductCollectionByCompetitor\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ConfItemUserCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"ConfItemUserCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ConfItemUserCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContactCareerCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"ContactCareerCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ContactCareerCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/CTISearchResultCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"CTISearchResultCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/CTISearchResultCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmailFolderColumnValuesSettingCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"EmailFolderColumnValuesSettingCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EmailFolderColumnValuesSettingCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"EmployeeCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EmployeeCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCareerCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"EmployeeCareerCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EmployeeCareerCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EnrchFoundAccountCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"EnrchFoundAccountCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EnrchFoundAccountCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EventTeamCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"EventTeamCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/EventTeamCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/PartnershipCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"PartnershipCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/PartnershipCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/LeadQualificationCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"LeadQualificationCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/LeadQualificationCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/MktgActivityCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"MktgActivityCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/MktgActivityCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCompetitorCollectionByCompetitor\" type=\"application/atom+xml;type=feed\" title=\"OpportunityCompetitorCollectionByCompetitor\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCompetitorCollectionByCompetitor\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityCompetitorCollectionBySupplier\" type=\"application/atom+xml;type=feed\" title=\"OpportunityCompetitorCollectionBySupplier\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityCompetitorCollectionBySupplier\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/OpportunityParticipantCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"OpportunityParticipantCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/OpportunityParticipantCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/QuickDialUserSettingsCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"QuickDialUserSettingsCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/QuickDialUserSettingsCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/RelationshipCollectionByAccountA\" type=\"application/atom+xml;type=feed\" title=\"RelationshipCollectionByAccountA\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/RelationshipCollectionByAccountA\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/RelationshipCollectionByAccountB\" type=\"application/atom+xml;type=feed\" title=\"RelationshipCollectionByAccountB\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/RelationshipCollectionByAccountB\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/ServiceObjectCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"ServiceObjectCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/ServiceObjectCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwSysAdminUnitCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwSysAdminUnitCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwSysAdminUnitCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountDuplicateCollectionByEntity1\" type=\"application/atom+xml;type=feed\" title=\"VwAccountDuplicateCollectionByEntity1\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountDuplicateCollectionByEntity1\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountDuplicateCollectionByEntity2\" type=\"application/atom+xml;type=feed\" title=\"VwAccountDuplicateCollectionByEntity2\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountDuplicateCollectionByEntity2\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountModuleHistoryCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwAccountModuleHistoryCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountModuleHistoryCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountRelationshipCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwAccountRelationshipCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountRelationshipCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAccountRelationshipCollectionByRelatedAccount\" type=\"application/atom+xml;type=feed\" title=\"VwAccountRelationshipCollectionByRelatedAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAccountRelationshipCollectionByRelatedAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwAnniversaryCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwAnniversaryCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwAnniversaryCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwContactRelationshipCollectionByRelatedAccount\" type=\"application/atom+xml;type=feed\" title=\"VwContactRelationshipCollectionByRelatedAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwContactRelationshipCollectionByRelatedAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwGroupSysAdminUnitCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwGroupSysAdminUnitCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwGroupSysAdminUnitCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwGroupSysAdminUnitCollectionByPortalAccount\" type=\"application/atom+xml;type=feed\" title=\"VwGroupSysAdminUnitCollectionByPortalAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwGroupSysAdminUnitCollectionByPortalAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwModuleHistoryCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwModuleHistoryCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwModuleHistoryCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwPortalOpportunityCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwPortalOpportunityCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwPortalOpportunityCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwPortalOpportunityCollectionByPartner\" type=\"application/atom+xml;type=feed\" title=\"VwPortalOpportunityCollectionByPartner\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwPortalOpportunityCollectionByPartner\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwProjectHierarchyCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwProjectHierarchyCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwProjectHierarchyCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwRelationshipCollectionByAccountA\" type=\"application/atom+xml;type=feed\" title=\"VwRelationshipCollectionByAccountA\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwRelationshipCollectionByAccountA\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwRelationshipCollectionByAccountB\" type=\"application/atom+xml;type=feed\" title=\"VwRelationshipCollectionByAccountB\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwRelationshipCollectionByAccountB\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwServiceRecepientsCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwServiceRecepientsCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwServiceRecepientsCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwSspAdminUnitCollectionByAccount\" type=\"application/atom+xml;type=feed\" title=\"VwSspAdminUnitCollectionByAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwSspAdminUnitCollectionByAccount\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwSspAdminUnitCollectionByPortalAccount\" type=\"application/atom+xml;type=feed\" title=\"VwSspAdminUnitCollectionByPortalAccount\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/VwSspAdminUnitCollectionByPortalAccount\" />\n <title />\n <updated>2020-04-09T11:22:10Z</updated>\n <author>\n <name />\n </author>\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/edit-media/Logo\" type=\"application/octet-stream\" title=\"Logo\" href=\"AccountCollection(guid'a0bf3e92-f36b-1410-0499-00155d043204')/Logo\" />\n <content type=\"application/xml\">\n <m:properties>\n <d:Id m:type=\"Edm.Guid\">a0bf3e92-f36b-1410-0499-00155d043204</d:Id>\n <d:Name>XT Group</d:Name>\n <d:AccountLogoId m:type=\"Edm.Guid\">69517c67-e5de-47db-ae50-df69447a12cf</d:AccountLogoId>\n <d:OwnerId m:type=\"Edm.Guid\">cad50d15-f28d-49fc-aa79-21615ac35b86</d:OwnerId>\n <d:CreatedOn m:type=\"Edm.DateTime\">2020-01-27T08:00:14Z</d:CreatedOn>\n <d:CreatedById m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:CreatedById>\n <d:ModifiedOn m:type=\"Edm.DateTime\">2020-01-10T10:12:35Z</d:ModifiedOn>\n <d:ModifiedById m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:ModifiedById>\n <d:ProcessListeners m:type=\"Edm.Int32\">0</d:ProcessListeners>\n <d:OwnershipId m:type=\"Edm.Guid\">e0ae3e02-f46b-1410-fb98-00155d043204</d:OwnershipId>\n <d:PrimaryContactId m:type=\"Edm.Guid\">017df77c-b01c-4554-b7eb-760ac91cd0d7</d:PrimaryContactId>\n <d:ParentId m:type=\"Edm.Guid\">00000000-0000-0000-0000-000000000000</d:ParentId>\n <d:IndustryId m:type=\"Edm.Guid\">bd7f1e4a-f36b-1410-c493-00155d043205</d:IndustryId>\n <d:Code>60</d:Code>\n <d:TypeId m:type=\"Edm.Guid\">03a75490-53e6-df11-971b-001d60e938c6</d:TypeId>\n <d:Phone>+1 212 753 2819</d:Phone>\n <d:AdditionalPhone>+1 212 753 2845</d:AdditionalPhone>\n <d:Fax></d:Fax>\n <d:Web>www.xtg.com</d:Web>\n <d:AddressTypeId m:type=\"Edm.Guid\">780bf68c-4b6e-df11-b988-001d60e938c6</d:AddressTypeId>\n <d:Address>17 Road Street</d:Address>\n <d:CityId m:type=\"Edm.Guid\">c0af42ea-f36b-1410-0299-00155d043204</d:CityId>\n <d:RegionId m:type=\"Edm.Guid\">00b03270-f36b-1410-fd98-00155d043204</d:RegionId>\n <d:Zip>10351</d:Zip>\n <d:CountryId m:type=\"Edm.Guid\">e0be1264-f36b-1410-fa98-00155d043204</d:CountryId>\n <d:AccountCategoryId m:type=\"Edm.Guid\">37ea507c-55e6-df11-971b-001d60e938c6</d:AccountCategoryId>\n <d:EmployeesNumberId m:type=\"Edm.Guid\">2c344115-55e6-df11-971b-001d60e938c6</d:EmployeesNumberId>\n <d:AnnualRevenueId m:type=\"Edm.Guid\">498aceb9-55e6-df11-971b-001d60e938c6</d:AnnualRevenueId>\n <d:Notes></d:Notes>\n <d:AlternativeName></d:AlternativeName>\n <d:GPSN>42.6558932018082</d:GPSN>\n <d:GPSE>-73.7562183364144</d:GPSE>\n <d:Completeness m:type=\"Edm.Int32\">100</d:Completeness>\n <d:PriceListId m:type=\"Edm.Guid\">00000000-0000-0000-0000-000000000000</d:PriceListId>\n </m:properties>\n </content>\n </entry>\n </m:inline>\n </link>\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/Manager\" type=\"application/atom+xml;type=entry\" title=\"Manager\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/Manager\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCollectionByManager\" type=\"application/atom+xml;type=feed\" title=\"EmployeeCollectionByManager\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeCollectionByManager\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeCareerCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeCareerCollectionByEmployee\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeCareerCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeFileCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeFileCollectionByEmployee\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeFileCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInFolderCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"EmployeeInFolderCollectionByEmployee\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeInFolderCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/EmployeeInTagCollectionByEntity\" type=\"application/atom+xml;type=feed\" title=\"EmployeeInTagCollectionByEntity\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/EmployeeInTagCollectionByEntity\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/SalaryCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"SalaryCollectionByEmployee\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/SalaryCollectionByEmployee\" />\n <link rel=\"http://schemas.microsoft.com/ado/2007/08/dataservices/related/VwEmployeesHierarchyCollectionByEmployee\" type=\"application/atom+xml;type=feed\" title=\"VwEmployeesHierarchyCollectionByEmployee\" href=\"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')/VwEmployeesHierarchyCollectionByEmployee\" />\n <title />\n <updated>2020-04-09T11:22:10Z</updated>\n <author>\n <name />\n </author>\n <content type=\"application/xml\">\n <m:properties>\n <d:Id m:type=\"Edm.Guid\">c31c7862-fe33-4a13-9bbc-0943fa08fd02</d:Id>\n <d:Name>William Walker</d:Name>\n <d:CreatedOn m:type=\"Edm.DateTime\">2017-03-30T14:50:04Z</d:CreatedOn>\n <d:CreatedById m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:CreatedById>\n <d:ModifiedOn m:type=\"Edm.DateTime\">2020-02-14T06:30:46.234Z</d:ModifiedOn>\n <d:ModifiedById m:type=\"Edm.Guid\">410006e1-ca4e-4502-a9ec-e54d922d2c00</d:ModifiedById>\n <d:ProcessListeners m:type=\"Edm.Int32\">0</d:ProcessListeners>\n <d:ContactId m:type=\"Edm.Guid\">227aab3b-7c0c-4181-abf9-81585563ab23</d:ContactId>\n <d:OrgStructureUnitId m:type=\"Edm.Guid\">d436a9ce-9690-4415-9e03-e8061d7cabb5</d:OrgStructureUnitId>\n <d:Notes></d:Notes>\n <d:JobId m:type=\"Edm.Guid\">11d68189-ced6-df11-9b2a-001d60e938c6</d:JobId>\n <d:FullJobTitle>Developer</d:FullJobTitle>\n <d:OwnerId m:type=\"Edm.Guid\">76929f8c-7e15-4c64-bdb0-adc62d383727</d:OwnerId>\n <d:CareerStartDate m:type=\"Edm.DateTime\">2019-09-08T00:00:00</d:CareerStartDate>\n <d:CareerDueDate m:type=\"Edm.DateTime\">0001-01-01T00:00:00</d:CareerDueDate>\n <d:ProbationDueDate m:type=\"Edm.DateTime\">2020-01-09T00:00:00</d:ProbationDueDate>\n <d:ReasonForDismissalId m:type=\"Edm.Guid\">00000000-0000-0000-0000-000000000000</d:ReasonForDismissalId>\n <d:AccountId m:type=\"Edm.Guid\">a0bf3e92-f36b-1410-0499-00155d043204</d:AccountId>\n <d:ManagerId m:type=\"Edm.Guid\">3e5bd47e-1ebd-41db-a9a6-a3560dcee3cb</d:ManagerId>\n </m:properties>\n </content>\n</entry>"
}
]
}
