Get an address
get
/crmRestApi/resources/11.13.18.05/hubOrganizations/{PartyNumber}/child/Address/{AddressNumber}
Request
Path Parameters
-
AddressNumber(required): string
The alternate unique identifier for the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix defined as in profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number.
-
PartyNumber(required): string
The unique alternate identifier for the organization party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number. Inactive records can't be updated.
Query Parameters
-
dependency: string
This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
Format: <attr1>=<val1>,<attr2>=<value2> -
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : hubOrganizations-Address-item-response
Type:
Show Source
object-
AddrElementAttribute1: string
Title:
Additional Address Element 1Maximum Length:150The additional address element to support flexible address format. -
AddrElementAttribute2: string
Title:
Additional Address Element 2Maximum Length:150The additional address element to support flexible address format. -
AddrElementAttribute3: string
Title:
Additional Address Element 3Maximum Length:150The additional address element to support flexible address format. -
AddrElementAttribute4: string
Title:
Additional Address Element 4Maximum Length:150The additional address element to support flexible address format. -
AddrElementAttribute5: string
Title:
Additional Address Element 5Maximum Length:150The additional address element to support flexible address format. -
Address1: string
Title:
Address Line 1Maximum Length:240The first line for address. -
Address2: string
Title:
Address Line 2Maximum Length:240The second line for address. -
Address3: string
Title:
Address Line 3Maximum Length:240The third line for address. -
Address4: string
Title:
Address Line 4Maximum Length:240The fourth line for address. -
AddressId: integer
(int64)
Read Only:
trueThe unique address identifier that is internally generated during create. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. -
AddressLinesPhonetic: string
Title:
Address Lines PhoneticMaximum Length:560The phonetic or Kana representation of the Kanji address lines (used in Japan). -
AddressNumber: string
Title:
Site NumberMaximum Length:30The alternate unique identifier for the address. One of AddressId, AddressNumber or SourceSystem and SourceSystemReferenceValue keys is used to identify the address record during update. If not specified, then it is automatically generated. Prefix defined as in profile option ZCA_PUID_PREFIX concatenated with an internally generated unique sequence number. -
AddressType: string
Title:
TypeThe type of address. -
Building: string
Title:
BuildingMaximum Length:240Specific building name or number at a given address. -
CalculateFormattedAddress: boolean
The formatted address.
-
City: string
Title:
CityMaximum Length:60The city element of Address. -
ClliCode: string
Title:
CLLI CodeMaximum Length:60The Common Language Location Identifier (CLLI) code. -
Comments: string
Title:
CommentsMaximum Length:2000The user comments for the address. -
ConflictId: integer
(int64)
Default Value:
0The unique identifier of the conflict. -
CorpCurrencyCode: string
Title:
Corporate CurrencyMaximum Length:15The corporate currency code associated with the addresses. A list of valid values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. This attribute is used by CRM Extensibility framework. -
Country: string
Title:
CountryMaximum Length:2The country code of the address. -
County: string
Title:
CountyMaximum Length:60The county element of address. -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64The user who created the address record. -
CreatedByModule: string
Default Value:
HZ_WSThe application module that created this organization record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups. -
CreatedByModule1: string
Title:
Created by ApplicationMaximum Length:30The application module that created this organization record. Defaulted to value HZ_WS for all web service based creation. A list of valid certification level codes is defined in the lookup HZ_CREATED_BY_MODULES. Review and update the codes using the Setup and Maintenance task, Manage Trading Community Common Lookups. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date and time when the record was created. -
CurcyConvRateType: string
Title:
Currency Conversion Rate TypeMaximum Length:30The currency conversion rate type associated with the address. This attribute is used by CRM Extensibility framework. A list of valid values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. -
CurrencyCode: string
Title:
Currency CodeMaximum Length:15The currency code related to the address. This attribute is used by CRM Extensibility framework. A list of valid values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. -
DateValidated: string
(date)
Title:
Validated DateThe date on which the address was last validated. -
Description: string
Title:
DescriptionMaximum Length:2000An extensive description of the location. -
DoNotMailFlag: boolean
Title:
Contact PreferencesDefault Value:falseIndicates that this address should not be used for mailing. -
DoNotValidateFlag: boolean
Title:
Don't ValidateMaximum Length:1Indicates that a particular location is not eligible for address validation regardless of the current Validation Status Code. -
DunsNumberC: string
Title:
D-U-N-S NumberMaximum Length:30The D-U-N-S number of the business location. -
EffectiveDate: string
(date)
The effective date of the address.
-
EndDateActive: string
(date)
Title:
End DateThe date after which this address is rendered inactive. -
FloorNumber: string
Title:
FloorMaximum Length:40The specific floor number at a given address or in a particular building when the building number is provided. -
FormattedAddress: string
Title:
AddressRead Only:trueThe formatted address information. -
FormattedAddress1: string
Title:
Formatted Address 1Read Only:trueThe formatted address information. -
FormattedMultilineAddress: string
Title:
AddressRead Only:trueThe formatted multiple line address information. -
FormattedMultilineAddress1: string
Title:
AddressRead Only:trueThe formatted multiple line address information. -
HouseType: string
Title:
House TypeMaximum Length:30The building type. A list of valid values is defined in the lookup HZ_HOUSE_TYPE. Review and update the codes using the Setup and Maintenance work area, Manage Standard Lookups task. -
LastUpdateDate: string
(date-time)
Title:
Last Updated DateRead Only:trueThe date and time when the record was last updated. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64The user who last updated the record. -
LastUpdateLogin: string
Title:
Last Update LoginRead Only:trueMaximum Length:32The session login associated to the user who last updated the contact record. -
Latitude: number
Title:
LatitudeThe attribute used to store latitude information for the location for spatial proximity and containment purposes. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LocationDirections: string
Title:
Location DirectionsMaximum Length:640The directions to the location. -
LocationId: integer
(int64)
Title:
Location IDThe unique identifier for the location record for this address. -
Longitude: number
Title:
LongitudeThe attribute used to store longitude information for the location for spatial proximity and containment purposes. -
Mailstop: string
Title:
Mail StopMaximum Length:60A user-defined code to indicate a mail drop point within their organization. -
ObjectVersionNumber: integer
(int32)
The attribute used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
-
ObjectVersionNumber1: integer
(int32)
The attribute used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
-
PartyId: integer
(int64)
Title:
Party IDThe unique Identifier of the account, contact, or household to which the address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the account, contact, or household record with which the address is associated. -
PartyName: string
Title:
Party NameRead Only:trueMaximum Length:360The name of the party. -
PartyNumber: string
Title:
Party NumberThe alternate unique identifier of the account, contact, or household to which the address is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact, or household record with which the address is associated. The default value is the value specified in the profile option ZCA_PUID_PREFIX concatenated with a unique generated sequence number. The value is updateable depending on the profile option HZ_GENERATE_PARTY_NUMBER. A list of valid values is defined in the profile option HZ_GENERATE_PARTY_NUMBER. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Profile Options task. Inactive records can't be updated. -
PartySiteName: string
Title:
Site NameMaximum Length:240The user defined name for the address. -
PartySourceSystem: string
Title:
Party Source SystemThe name of external source system of the account, contact, or household with which the address is associated. Part of Alternate Key for the account, contact, or household record (along with PartyourceSystemReferenceValue). One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. -
PartySourceSystemReferenceValue: string
Title:
Party Source System Reference ValueIdentifier from external source system for the account, contact or household with which the address is associated. Part of Alternate Key (along with PartySourceSystem) . One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to identify the account, contact or household record with which the address is associated. -
PartyUniqueName: string
Title:
Unique Party NameRead Only:trueMaximum Length:900The unique party name of the party record. -
PostalCode: string
Title:
Postal CodeMaximum Length:60The postal code as defined by the formal countrywide postal system. -
PostalPlus4Code: string
Title:
Postal Code ExtensionMaximum Length:20The four digit extension to the United States Postal ZIP code. -
PrimaryFlag: boolean
Title:
PrimaryMaximum Length:1Default Value:falseIndicates whether this is the primary address of the associated object. Accepts values Y for primary contact, N for all others. -
Province: string
Title:
ProvinceMaximum Length:60The province element of Address. -
SalesAccountFlag: boolean
Title:
Sales Account FlagRead Only:trueMaximum Length:10Default Value:falseIndicates whether the associated customer is a sales account. -
SourceSystem: string
The name of external source system for the address denoted by a code, which is defined by an administrator as part of system setup. The value for this attribute should be predefined in the lookup type HZ_ORIG_SYSTEMS_VL using the setup task Manage Trading Community Source Systems. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
-
SourceSystemReferenceValue: string
The unique identifier for the address from the external source. SourceSystem and SourceSystemReference combination is unique and is used as the foreign key to identify an address.
-
SSROwnerTableName: string
Read Only:
trueMaximum Length:255The name of the table that holds the record data and is referenced to manage source system reference. -
SSRPartyOwnerTableName: string
Read Only:
trueMaximum Length:255Default Value:HZ_PARTIESThe name of the table that holds the party record data and is referenced to manage source system reference. -
StartDateActive: string
(date)
Title:
Start DateThe date from which this address is active. Defaulted to the current system date if not provided during create. -
State: string
Title:
StateMaximum Length:60The state element of Address. -
Status: string
Title:
StatusMaximum Length:1Default Value:AAn internal application determined flag indicating status of the address. Status codes are defined by the lookup HZ_STATUS. -
ValidatedFlag: boolean
Title:
ValidatedMaximum Length:1Default Value:falseIndicates whether the location was validated. Y for validated, N for invalidated. If the value is True, then the location is validated. The value is internally set by system during address cleansing. -
ValidationStartDate: string
(date)
Read Only:
trueThe date on which the validation starts. Internally set by system during address cleansing. -
ValidationStatusCode: string
Title:
Validation StatusMaximum Length:30The standardized status code that describes the results of the validation.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Links
- CountriesLOV
-
Parameters:
- finder:
ObsoleteEnabledFlagFinder%3BBindEnabledFlag%3DY%2CBindObsoleteFlag%3DN
The list of values indicating the country of the address, such as US and UK.
The following properties are defined on the LOV link relation:- Source Attribute: Country; Target Attribute: TerritoryCode
- Display Attribute: TerritoryShortName
- finder:
- FuseTypeLookupVA
-
Parameters:
- finder:
LookupTypeTagFinder%3BBindLookupType%3DPARTY_SITE_USE_CODE%2CBindTag%3DSALES_CLOUD
The following properties are defined on the LOV link relation:- Source Attribute: AddressType; Target Attribute: LookupCode
- Display Attribute: Meaning
- finder:
- HouseTypeLookupLOV
-
Parameters:
- finder:
LookupTypeFinder%3BLookupType%3DHZ_HOUSE_TYPE
The list of values indicating the house type of the address, such as House Boat and Trailer.
The following properties are defined on the LOV link relation:- Source Attribute: HouseType; Target Attribute: LookupCode
- Display Attribute: Meaning
- finder:
- PartySiteEO_setCurrentOverallPrimaryFlag
-
Parameters:
- AddressNumber:
$request.path.AddressNumber - PartyNumber:
$request.path.PartyNumber
- AddressNumber:
- PartySiteEO_setCurrentPrimaryFlag
-
Parameters:
- AddressNumber:
$request.path.AddressNumber - PartyNumber:
$request.path.PartyNumber
- AddressNumber:
Examples
The following example shows how to get an address of hug organization by submitting a get request on the REST resource using cURL.
cURL Command
curl -u <username:password> \
'https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/hubOrganizations/100000018566151/child/Address/100000018566154'
-X GET
Example of Response Body
The following shows an example of the response body in JSON format.
{
"PartyId": 100000018566152,
"PartyNumber": "100000018566151",
"PartySourceSystem": null,
"PartySourceSystemReferenceValue": null,
"AddressId": 100000018566155,
"AddressNumber": "100000018566154",
"Comments": null,
"ObjectVersionNumber": 1,
"DoNotMailFlag": false,
"CorpCurrencyCode": null,
"CreatedBy": "SETUP",
"CreatedByModule": "XLE_CREATE_LE",
"CreationDate": "2010-06-28T08:54:16.710+00:00",
"CurcyConvRateType": null,
"CurrencyCode": null,
"EndDateActive": "4712-12-31",
"FormattedAddress": "456 Columbus Avenue,CHICAGO, IL 60601-3475",
"FormattedMultilineAddress": "456 Columbus Avenue, CHICAGO, IL 60601-3475",
"LastUpdateDate": "2010-06-28T08:54:17.891+00:00",
"LastUpdateLogin": "8A1A15F71CDE6DD6E04044987CF074C0",
"LastUpdatedBy": "SETUP",
"LocationId": 205,
"Mailstop": null,
"PrimaryFlag": true,
"StartDateActive": "2010-06-28",
"Status": "A",
"AddrElementAttribute1": null,
"ObjectVersionNumber1": 1,
"AddrElementAttribute2": null,
"AddrElementAttribute3": null,
"AddrElementAttribute4": null,
"AddrElementAttribute5": null,
"Address1": "456 Columbus Avenue",
"Address2": null,
"Address3": null,
"Address4": null,
"AddressLinesPhonetic": null,
"Building": null,
"CalculateFormattedAddress": "false",
"City": "Chicago",
"ClliCode": null,
"Country": "US",
"County": "Cook",
"DateValidated": null,
"Description": "Chicago Subassembly Plant 1 used in Operations SoB",
"FloorNumber": null,
"FormattedAddress1": "456 Columbus Avenue,CHICAGO, IL 60601-3475",
"FormattedMultilineAddress1": "456 Columbus Avenue CHICAGO, IL 60601-3475",
"HouseType": null,
"Latitude": null,
"LocationDirections": null,
"Longitude": null,
"PostalCode": "60601-3475",
"PostalPlus4Code": null,
"Province": null,
"State": "IL",
"ValidatedFlag": null,
"ValidationStartDate": null,
"ValidationStatusCode": null,
"SourceSystem": null,
"SourceSystemReferenceValue": null,
"SSROwnerTableName": "HZ_PARTY_SITES",
"EffectiveDate": null,
"SSRPartyOwnerTableName": "HZ_PARTIES",
"CreatedByModule1": "XLE_CREATE_LE",
"AddressType": null,
"ConflictId": 0,
"DoNotValidateFlag": null,
"DunsNumberC": null,
"PartySiteName": null,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/hubOrganizations/100000018566151/child/Address/100000018566154",
"name": "Address",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000002770400000002737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000017371007E00020000000178"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/hubOrganizations/100000018566151/child/Address/100000018566154",
"name": "Address",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/hubOrganizations/100000018566151",
"name": "hubOrganizations",
"kind": "item"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/hubOrganizations/100000018566151/child/Address/100000018566154/action/PartySiteEO_setCurrentPrimaryFlag",
"name": "PartySiteEO_setCurrentPrimaryFlag",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/hubOrganizations/100000018566151/child/Address/100000018566154/action/PartySiteEO_setCurrentOverallPrimaryFlag",
"name": "PartySiteEO_setCurrentOverallPrimaryFlag",
"kind": "other"
}
]
}