ODBC Driver for Workday

Build 23.0.8839

PeoplePublicContactInformation

Retrieves a person's public contact information.

Workday Resource Information

Retrieves public contact information for the person with the specified ID.

Secured by: REST API Public

Aggregate Fields

The 本製品 represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

Addresses_Aggregate


[{
  addressLine4Local: Text /* Local Address Line 4 for the address. */
  citySubdivision2Local: Text /* City Subdivision 2 - Local for the address. */
  addressLine8Local: Text /* Local Address Line 8 for the address. */
  citySubdivision1Local: Text /* City Subdivision 1 - Local for the address. */
  addressLine1: Text /* Address Line 1 for the address. */
  addressLine9: Text /* Address Line 9 for the address. */
  regionSubdivision1Local: Text /* Region Subdivision 1 - Local for the address. */
  addressLine8: Text /* Address Line 8 for the address. */
  addressLine2: Text /* Address Line 2 for the address. */
  fullFormattedAddress: Text /* Full Formatted Address */
  addressLine6Local: Text /* Local Address Line 6 for the address. */
  regionSubdivision2: Text /* Region Subdivision 2 for the address. */
  countryCity: { /* \~Country\~ City */
      descriptor: Text /* A preview of the instance */
      id: Text /* Id of the instance */
  }
  addressLine4: Text /* Address Line 4 for the address. */
  postalCode: Text /* The postal code for the address. */
  fullFormattedLocalAddress: Text /* Full Formatted Local Address */
  addressLine1Local: Text /* Local Address Line 1 for the address. */
  citySubdivision1: Text /* City Subdivision 1 for the address. */
  addressLine6: Text /* Address Line 6 for the address. */
  usage: { /* Address Instance Referenced */
      primary: Boolean /* True if the communication method has any  primary usage type. */
      usageType: { /* Returns the usage type for a given communication method. */
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }
      usedFor: [{
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }]
      public: Boolean /* True if the communication method is public. If no results are returned, the communication method is private. */
  }
  city: Text /* City for the address. */
  addressLine3: Text /* Address Line 3 for the address. */
  citySubdivision2: Text /* City Subdivision 2 for the address. */
  addressLine9Local: Text /* Local Address Line 9 for the address. */
  effective: Date /* The Effective Date for the address. */
  addressLine7Local: Text /* Local Address Line 7 for the address. */
  addressLine5: Text /* Address Line 5 for the address. */
  regionSubdivision1: Text /* Region Subdivision 1 for the address. */
  cityLocal: Text /* City - Local for the address. */
  addressLine2Local: Text /* Local Address Line 2 for the address. */
  countryRegion: { /* Country Region */
      descriptor: Text /* A preview of the instance */
      id: Text /* Id of the instance */
  }
  addressLine3Local: Text /* Local Address Line 3 for the address. */
  country: { /* \~Country\~ */
      descriptor: Text /* A preview of the instance */
      id: Text /* Id of the instance */
  }
  addressLine5Local: Text /* Local Address Line 5 for the address. */
  addressLine7: Text /* Address Line 7 for the address. */
  id: Text /* Id of the instance */
}]

Emails_Aggregate


[{
  usage: { /* Current e-mail interface for the e-mail reference */
      primary: Boolean /* True if the communication method has any  primary usage type. */
      usageType: { /* Returns the usage type for a given communication method. */
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }
      usedFor: [{
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }]
      public: Boolean /* True if the communication method is public. If no results are returned, the communication method is private. */
  }
  emailAddress: Text /* The email address. */
  emailComment: Text /* Comment associated with the email. */
  id: Text /* Id of the instance */
}]

InstantMessengers_Aggregate


[{
  comment: Text /* The comment associated with the instant messenger account. */
  type: { /* Instant Messenger Type */
      descriptor: Text /* A preview of the instance */
  }
  userName: Text /* The instant messenger account username. */
  usage: { /* Instant Messenger for the Instant Messenger Reference */
      primary: Boolean /* True if the communication method has any  primary usage type. */
      usageType: { /* Returns the usage type for a given communication method. */
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }
      usedFor: [{
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }]
      public: Boolean /* True if the communication method is public. If no results are returned, the communication method is private. */
  }
  id: Text /* Id of the instance */
}]

PhoneNumbers_Aggregate


[{
  usage: { /* Current phone for the reference */
      primary: Boolean /* True if the communication method has any  primary usage type. */
      usageType: { /* Returns the usage type for a given communication method. */
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }
      usedFor: [{
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }]
      public: Boolean /* True if the communication method is public. If no results are returned, the communication method is private. */
  }
  countryPhoneCode: { /* Phone \~country\~ */
      countryPhoneCode: Text /* The phone code for a country. */
      country: { /* \~Country\~ Phone Code for \~Country\~ */
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }
      descriptor: Text /* A preview of the instance */
      id: Text /* Id of the instance */
  }
  completePhoneNumber: Text /* The complete phone number. */
  extension: Text /* The phone extension. */
  deviceType: { /* Phone device type */
      id: Text /* Id of the instance */
      descriptor: Text /* A preview of the instance */
  }
  id: Text /* Id of the instance */
  descriptor: Text /* A preview of the instance */
}]

WebAddresses_Aggregate


[{
  comment: Text /* The comment associated with the web address. */
  usage: { /* Current web address interface for the web address reference */
      primary: Boolean /* True if the communication method has any  primary usage type. */
      usageType: { /* Returns the usage type for a given communication method. */
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }
      usedFor: [{
          descriptor: Text /* A preview of the instance */
          id: Text /* Id of the instance */
      }]
      public: Boolean /* True if the communication method is public. If no results are returned, the communication method is private. */
  }
  url: Text /* The complete URL address for the web address. */
  id: Text /* Id of the instance */
}]

Columns

Name Type Description
People_Id String The Workday ID of the People that owns this
Addresses_Aggregate String Supported for: SELECT. A JSON aggregate. The public address references for the person.
Emails_Aggregate String Supported for: SELECT. A JSON aggregate. The public email references for the person.
InstantMessengers_Aggregate String Supported for: SELECT. A JSON aggregate. The public instant messenger account references for the person.
PhoneNumbers_Aggregate String Supported for: SELECT. A JSON aggregate. The public phone number references for the person.
WebAddresses_Aggregate String Supported for: SELECT. A JSON aggregate. The public web address references for the person.
Universal_ID_Prompt String Only used when a People_Id filter is not provided. The Universal ID of the person you want to retrieve.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839