取得操作を使用した保存済検索の問合せ
次のドキュメントでは、保存済検索を上書きする問合せのために、Get操作で異なる個別パラメータを渡します。 エンティティは、すべてのGet操作に必要な問合せパラメータであることに注意してください。
制限
取得するデータ行数に制限を設定する方法。
cURLコマンド
https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries/59783e65-0513-4169-9fae-db9d7d1b105c/results?entity=Account&limit=3
レスポンス・ペイロードの例
{
"items": [
{
"PreferredFunctionalCurrency_localizedValue": null,
"PrimaryIndustry": {
"ClassCode": "2000",
"CodeAssignmentId": 300100169114658,
"Primary": true,
"ClassCode_localizedValue": "Industrial Manufacturing"
},
"PartyRecordSet_localizedValue": null,
"PreferredFunctionalCurrency": null,
"MinorityOwnedType": null,
"ListOfContacts": null,
"PrimaryPhone": null,
"PartyNumber": null,
"LegalStatus_localizedValue": null,
"LastUpdateDate": null,
"EmployeesAtPrimaryAddress": null,
"DomesticUltimateDUNSNumberC": null,
"CurrentFiscalYearPotentialRevenueAmount": null,
"ListOfResourceIdsInTheManagementChainOfAResourceForTheTeam": null,
"_entity": "Account",
"ListOfResourceIdsForTheTeam": null,
"CeoName": null,
"PrimaryEmail": null,
"OrganizationSize": null,
"LastUpdatedBy": null,
"ListOfIndustries": null,
"DbRating": null,
"PartyRecordSet": null,
"ParentDUNSNumberC": null,
"PrimaryIM": null,
"ListOfOrganizationTypes": null,
"OrganizationName": null,
"ObjectVersionNumber": null,
"LaborSurplusInd": null,
"ListOfResourceIdsThatAreOwnersOfAnAssociatedTerritory": null,
"LegalStatus": null,
"NamedFlag": null,
"PrimaryContact": null,
"OrganizationProfileId": null,
"JgzzFiscalCode": null,
"GlobalUltimateDUNSNumberC": null,
"PartyId": 300100169114649,
"OwnerPartyId": null,
"OrganizationSize_localizedValue": null,
"SalesProfileType_localizedValue": null,
"PartyUniqueName": "3M (St. Paul, US)",
"IncorpYear": null,
"ListOfResourceIdsThatAreMembersOfATerritoryThatIsAnAncestorOfAnAssociatedTerritory": null,
"ListOfResourceIdsThatAreMembersOfAnAssociatedTerritory": null,
"ListOfResourceIdsInTheManagementChainOfTheOwner": null,
"ExportInd": null,
"SalesProfileType": null,
"ImportInd": null,
"PrimaryOrganizationType": null,
"DUNSNumberC": null,
"EmployeesTotal": null,
"PrimaryAddress": {
"CountryCode_localizedValue": "United States",
"PostalCode": "55144",
"State": "MN",
"Address1": "3M Center",
"CountryCode": "US",
"CurrencyCode": "USD",
"OverallPrimary": true,
"City": "St. Paul",
"FormattedAddress": "3M Center,ST. PAUL, MN 55144",
"PartySiteId": 300100169114653,
"IdentifyingAddressFlag": true,
"ListOfPartySiteUses": [
{
"PrimaryPerType": true,
"SiteUseType_localizedValue": "Bill to",
"PartySiteUseId": 300100169114654,
"SiteUseType": "BILL_TO"
},
{
"PrimaryPerType": true,
"SiteUseType_localizedValue": "Business",
"PartySiteUseId": 300100169114655,
"SiteUseType": "BUSINESS"
}
]
},
"Owner": {
"PartyId": 100010025532672
},
"ListOfPhones": null,
"EmployeesAtPrimaryAddressEstimation_localizedValue": null,
"ListOfAddresses": null,
"EmployeesAtPrimaryAddressEstimation": null,
"ListOfTerritories": null,
"PrimaryURL": null,
"Disadv8aInd": null,
"ListOfResourcesForTheTeam": null,
"ListOfIMs": null,
"CreationDate": null,
"CurrencyCode": null,
"SalesProfileStatus_localizedValue": null,
"LineOfBusiness": null,
"SalesProfileStatus": null,
"ListOfURLs": null,
"ListOfTerritoryIds": null,
"ListOfEmails": null,
"EnquiryDUNS": null,
"CreatedBy": null,
"SalesAccountId": null,
"CurrencyCode_localizedValue": null,
"ListOfTerritoryIdsThatAreAncestorsOfAnAssociatedTerritory": null,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries/59783e65-0513-4169-9fae-db9d7d1b105c/results/300100169114649?limit=2&entity=Account",
"kind": "item",
"name": "self"
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/entities/Account/300100169114649?limit=2",
"kind": "item",
"name": "canonical"
},
{
"rel": "parent",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries/59783e65-0513-4169-9fae-db9d7d1b105c/results?entity=Account",
"kind": "collection",
"name": "parent"
}
]
},
...
}
フィールド
出力ペイロードで取得するフィールドのリストを指定します。 *(asterisk)ベースのフィルタリングがサポートされています。
cURLコマンド
https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries/59783e65-0513-4169-9fae-db9d7d1b105c/results?entity=Account&offset=3&fields=PartyUniqueName
レスポンス・ペイロードの例
{
"items": [
{
"_entity": "Account",
"PartyUniqueName": "~RESTOppAccName~ (New York, US)",
"PartyId": 300100264860806,
"links": [
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/entities/Account/300100264860806?metaModelUuid=81f4c054-90c6-45a0-a096-beec3ad68d42&entity=Account&fields=PartyUniqueName",
"kind": "item",
"name": "canonical"
},
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries/59783e65-0513-4169-9fae-db9d7d1b105c/results/300100264860806?metaModelUuid=81f4c054-90c6-45a0-a096-beec3ad68d42&entity=Account&fields=PartyUniqueName",
"kind": "item",
"name": "self"
},
{
"rel": "parent",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/searchResources/11.13.18.05/custom-actions/queries/59783e65-0513-4169-9fae-db9d7d1b105c/results?metaModelUuid=81f4c054-90c6-45a0-a096-beec3ad68d42&entity=Account",
"kind": "collection",
"name": "parent"
}
]
},
...
}