SQL Server / Creatio API / Get an object collection instance by Id of another object collection instance
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
-- 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
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'ForceUseSession', 'true'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'BPMCSRF', '{{BPMCSRF}}'
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 @http, 'QuickGetSb', @success OUT, 'https://myserver.com/0/ServiceModel/EntityDataService.svc/Collection1Collection(guid''Id'')/Collection2', @sbResponseBody
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
RETURN
END
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/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:17:44Z</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>
-- 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 @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)'
SELECT @i = @i + 1
END
DECLARE @updated nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @updated OUT, 'updated'
DECLARE @content_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @content_type OUT, 'content|(type)'
DECLARE @d_Id_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_Id_m_type OUT, 'content|m:properties|d:Id|(m:type)'
DECLARE @d_Id nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Id OUT, 'content|m:properties|d:Id'
DECLARE @d_Name nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Name OUT, 'content|m:properties|d:Name'
DECLARE @d_AccountLogoId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AccountLogoId_m_type OUT, 'content|m:properties|d:AccountLogoId|(m:type)'
DECLARE @d_AccountLogoId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AccountLogoId OUT, 'content|m:properties|d:AccountLogoId'
DECLARE @d_OwnerId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_OwnerId_m_type OUT, 'content|m:properties|d:OwnerId|(m:type)'
DECLARE @d_OwnerId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_OwnerId OUT, 'content|m:properties|d:OwnerId'
DECLARE @d_CreatedOn_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CreatedOn_m_type OUT, 'content|m:properties|d:CreatedOn|(m:type)'
DECLARE @d_CreatedOn nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CreatedOn OUT, 'content|m:properties|d:CreatedOn'
DECLARE @d_CreatedById_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CreatedById_m_type OUT, 'content|m:properties|d:CreatedById|(m:type)'
DECLARE @d_CreatedById nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CreatedById OUT, 'content|m:properties|d:CreatedById'
DECLARE @d_ModifiedOn_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ModifiedOn_m_type OUT, 'content|m:properties|d:ModifiedOn|(m:type)'
DECLARE @d_ModifiedOn nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ModifiedOn OUT, 'content|m:properties|d:ModifiedOn'
DECLARE @d_ModifiedById_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ModifiedById_m_type OUT, 'content|m:properties|d:ModifiedById|(m:type)'
DECLARE @d_ModifiedById nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ModifiedById OUT, 'content|m:properties|d:ModifiedById'
DECLARE @d_ProcessListeners_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ProcessListeners_m_type OUT, 'content|m:properties|d:ProcessListeners|(m:type)'
DECLARE @d_ProcessListeners int
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_ProcessListeners OUT, 'content|m:properties|d:ProcessListeners'
DECLARE @d_OwnershipId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_OwnershipId_m_type OUT, 'content|m:properties|d:OwnershipId|(m:type)'
DECLARE @d_OwnershipId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_OwnershipId OUT, 'content|m:properties|d:OwnershipId'
DECLARE @d_PrimaryContactId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_PrimaryContactId_m_type OUT, 'content|m:properties|d:PrimaryContactId|(m:type)'
DECLARE @d_PrimaryContactId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_PrimaryContactId OUT, 'content|m:properties|d:PrimaryContactId'
DECLARE @d_ParentId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_ParentId_m_type OUT, 'content|m:properties|d:ParentId|(m:type)'
DECLARE @d_ParentId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_ParentId OUT, 'content|m:properties|d:ParentId'
DECLARE @d_IndustryId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_IndustryId_m_type OUT, 'content|m:properties|d:IndustryId|(m:type)'
DECLARE @d_IndustryId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_IndustryId OUT, 'content|m:properties|d:IndustryId'
DECLARE @d_Code int
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_Code OUT, 'content|m:properties|d:Code'
DECLARE @d_TypeId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_TypeId_m_type OUT, 'content|m:properties|d:TypeId|(m:type)'
DECLARE @d_TypeId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_TypeId OUT, 'content|m:properties|d:TypeId'
DECLARE @d_Phone nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Phone OUT, 'content|m:properties|d:Phone'
DECLARE @d_AdditionalPhone nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AdditionalPhone OUT, 'content|m:properties|d:AdditionalPhone'
DECLARE @d_Web nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Web OUT, 'content|m:properties|d:Web'
DECLARE @d_AddressTypeId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AddressTypeId_m_type OUT, 'content|m:properties|d:AddressTypeId|(m:type)'
DECLARE @d_AddressTypeId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AddressTypeId OUT, 'content|m:properties|d:AddressTypeId'
DECLARE @d_Address nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_Address OUT, 'content|m:properties|d:Address'
DECLARE @d_CityId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CityId_m_type OUT, 'content|m:properties|d:CityId|(m:type)'
DECLARE @d_CityId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CityId OUT, 'content|m:properties|d:CityId'
DECLARE @d_RegionId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_RegionId_m_type OUT, 'content|m:properties|d:RegionId|(m:type)'
DECLARE @d_RegionId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_RegionId OUT, 'content|m:properties|d:RegionId'
DECLARE @d_Zip int
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_Zip OUT, 'content|m:properties|d:Zip'
DECLARE @d_CountryId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_CountryId_m_type OUT, 'content|m:properties|d:CountryId|(m:type)'
DECLARE @d_CountryId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_CountryId OUT, 'content|m:properties|d:CountryId'
DECLARE @d_AccountCategoryId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AccountCategoryId_m_type OUT, 'content|m:properties|d:AccountCategoryId|(m:type)'
DECLARE @d_AccountCategoryId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AccountCategoryId OUT, 'content|m:properties|d:AccountCategoryId'
DECLARE @d_EmployeesNumberId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_EmployeesNumberId_m_type OUT, 'content|m:properties|d:EmployeesNumberId|(m:type)'
DECLARE @d_EmployeesNumberId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_EmployeesNumberId OUT, 'content|m:properties|d:EmployeesNumberId'
DECLARE @d_AnnualRevenueId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_AnnualRevenueId_m_type OUT, 'content|m:properties|d:AnnualRevenueId|(m:type)'
DECLARE @d_AnnualRevenueId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_AnnualRevenueId OUT, 'content|m:properties|d:AnnualRevenueId'
DECLARE @d_GPSN nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_GPSN OUT, 'content|m:properties|d:GPSN'
DECLARE @d_GPSE nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_GPSE OUT, 'content|m:properties|d:GPSE'
DECLARE @d_Completeness_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_Completeness_m_type OUT, 'content|m:properties|d:Completeness|(m:type)'
DECLARE @d_Completeness int
EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @d_Completeness OUT, 'content|m:properties|d:Completeness'
DECLARE @d_PriceListId_m_type nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'ChilkatPath', @d_PriceListId_m_type OUT, 'content|m:properties|d:PriceListId|(m:type)'
DECLARE @d_PriceListId nvarchar(4000)
EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @d_PriceListId OUT, 'content|m:properties|d:PriceListId'
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @xmlResponse
END
GO
Curl Command
curl -X GET
-H "ForceUseSession: true"
-H "BPMCSRF: {{BPMCSRF}}"
https://myserver.com/0/ServiceModel/EntityDataService.svc/Collection1Collection(guid'Id')/Collection2
Postman Collection Item JSON
{
"name": "Get an object collection instance by Id of another object collection instance",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "ForceUseSession",
"type": "text",
"value": "true"
},
{
"key": "BPMCSRF",
"type": "text",
"value": "{{BPMCSRF}}"
}
],
"body": {
"mode": "raw",
"raw": ""
},
"url": {
"raw": "{{BaseURI}}/0/ServiceModel/EntityDataService.svc/{{CollectionName1}}Collection(guid'{{ObjectId1}}')/{{CollectionName2}}",
"host": [
"{{BaseURI}}"
],
"path": [
"0",
"ServiceModel",
"EntityDataService.svc",
"{{CollectionName1}}Collection(guid'{{ObjectId1}}')",
"{{CollectionName2}}"
]
},
"description": "Request for getting an instance of a collection of objects by Id of an instance in another collection."
},
"response": [
{
"name": "[200] Gets an instance of a collection of objects by Id of an instance in another collection of objects",
"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')/Account",
"protocol": "https",
"host": [
"myserver",
"com"
],
"path": [
"0",
"ServiceModel",
"EntityDataService.svc",
"EmployeeCollection(guid'c31c7862-fe33-4a13-9bbc-0943fa08fd02')",
"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:17:44 GMT"
},
{
"key": "Content-Length",
"value": "28567"
}
],
"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/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:17:44Z</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>"
}
]
}
