Get all planning and zoning workflow communication items
get
/fscmRestApi/resources/11.13.18.05/publicSectorPzWorkflowCommunications
Request
Query Parameters
-
dependency: string
This parameter specifies dependencies which are attributes that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The attributes 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 attributes 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 attributes. 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 attributes. Only the specified attributes are returned, which means that if no attributes are specified, no attributes 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 attributes. 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 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- findByBRFCriteria: Finds workflow communication data that satisfies the criteria provided.
- PrimaryKey: Finds workflow communication data with the specified key. Finder Variables:
- LnpRecordKey; integer; The unique identifier for the record key.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified attributes. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2 -
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Response
Supported Media Types
- application/vnd.oracle.adf.resourcecollection+json
Default Response
The following table describes the default response for this task.
Root Schema : publicSectorPzWorkflowCommunications
Type:
Show Source
object-
count(optional):
integer
Title:
CountThe number of resource instances returned in the current range. -
hasMore(optional):
boolean
Title:
HasMoreIndicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false. -
items(optional):
array Items
Title:
ItemsThe items in the collection. -
limit(optional):
integer
Title:
LimitThe actual paging size used by the server. -
links(optional):
array Items
Title:
ItemsThe link relations associated with the resource instance. -
offset(optional):
integer
Title:
OffsetThe offset value used in the current page.
Nested Schema : Items
Type:
arrayTitle:
ItemsThe link relations associated with the resource instance.
Show Source
Nested Schema : publicSectorPzWorkflowCommunications-item
Type:
Show Source
object-
AboutToExpireDate(optional):
string(date-time)
Title:
About to Expire DateThe date when the notification about an expiring license or planning application is sent. -
AddressKey(optional):
integer(int64)
The parcel address key.
-
AgencyId(optional):
integer(int32)
The identifier for a public sector agency. This is usually an alphanumeric identifier for a city, county, or state, but it can also be the name of a city, county, or state.
-
AppAcceptDate(optional):
string(date-time)
Title:
Acceptance DateIdentifies the accepted date of the application. -
ApplAteDate(optional):
string(date-time)
Title:
Application About to Expire DateIdentifies the date on which an about-to-expire notification is sent for the application. -
ApplExpirationDate(optional):
string(date-time)
Title:
Application Expiration DateThe date the application expires. -
Applicant(optional):
integer(int64)
The party ID of the planning application applicant.
-
ApplicantAddress1(optional):
string
Title:
Applicant Address Line 1Maximum Length:240The first line of the planning application applicant address. -
ApplicantAddress2(optional):
string
Title:
Applicant Address Line 2Maximum Length:240The second line of the planning application applicant address. -
ApplicantBizProfileId(optional):
integer(int64)
The business profile used by the applicant.
-
ApplicantCity(optional):
string
Title:
Applicant CityMaximum Length:60The city in the planning application applicant address. -
ApplicantCountry(optional):
string
Title:
Applicant CountryMaximum Length:3The country in the planning application applicant address. -
ApplicantCounty(optional):
string
Title:
Applicant CountyMaximum Length:60The county in the planning application applicant address. -
ApplicantEmailAddress1(optional):
string
Title:
Applicant Email 1Maximum Length:320The first email address of the planning application applicant. -
ApplicantEmailAddress2(optional):
string
Title:
Applicant Email 2Maximum Length:320The second email address of the planning application applicant. -
ApplicantPersonName(optional):
string
Title:
Applicant Full NameMaximum Length:450The planning application applicant name. -
ApplicantPhoneAreaCode(optional):
string
Maximum Length:
10The area code in the phone number of the planning application applicant. -
ApplicantPhoneCountryCode(optional):
string
Maximum Length:
10The country code in the phone number of the planning application applicant. -
ApplicantPhoneExtension(optional):
string
Title:
Applicant Phone ExtensionMaximum Length:20The phone number extension for the planning application applicant. -
ApplicantPhoneNumber(optional):
string
Title:
Applicant Phone NumberMaximum Length:60The planning application applicant phone number. -
ApplicantPostalCode(optional):
string
Title:
Applicant Postal CodeMaximum Length:60The postal code in the planning application applicant address. -
ApplicantProfileId(optional):
integer(int64)
The user profile of the applicant.
-
ApplicantProvince(optional):
string
Title:
Applicant ProvinceMaximum Length:60The province in the planning application applicant address. -
ApplicantState(optional):
string
Title:
Applicant StateMaximum Length:60The state in the planning application applicant address. -
ApplicantUserId(optional):
string
Title:
Applicant User IDMaximum Length:20User ID of the applicant. -
AssigneeEmail(optional):
string
Title:
Assigned Planner EmailThe email for the workflow task assignee. -
AssigneeName(optional):
string
Title:
Assigned Planner NameThe name of the workflow task assignee. -
AssigneePhone(optional):
string
Title:
Assigned Planner PhoneThe phone for the workflow task assignee. -
AssigneeUserid(optional):
string
Title:
Assigned PlannerMaximum Length:64The unique user ID of the agency staff assigned to the transaction. -
BalanceDue(optional):
number
Title:
Fees Balance DueThe balance due for the planning application. -
CancellationReason(optional):
string
Title:
Cancellation ReasonMaximum Length:1000Identifies the cancelation reason of the planning application. -
CancelledByName(optional):
string
Title:
Canceled by NameIdentifies the user name of the person who canceled the application. -
CancelledByUserID(optional):
string
Title:
Canceled by User IDMaximum Length:64Identifies who canceled the planning application. -
CancelledDate(optional):
string(date-time)
Title:
Cancellation DateIdentifies the cancelation date of the planning application. -
Classification(optional):
string
Maximum Length:
3The planning application classification. -
ClassificationMeaning(optional):
string
Title:
ClassificationMaximum Length:80The description for the classification of the planning application type. -
CreatedBy(optional):
string
Title:
Created by User IDMaximum Length:64Identifies the user who created the application by the login ID. -
CreatedByName(optional):
string
Title:
Created by NameIdentifies the user name of the person who created the application. -
CreationDate(optional):
string(date-time)
Title:
Creation DateIdentifies the creation date of the planning application. -
CurrencyCode(optional):
string
Title:
CurrencyMaximum Length:3Identifies the currency code. -
DelinquentDate(optional):
string(date-time)
The date the license becomes delinquent.
-
DistrictName(optional):
string
Maximum Length:
50The name of the district in which the property is located. -
ExpirationDate(optional):
string(date-time)
Title:
Expiration DateThe date the license or planning application is no longer valid. -
ExpirationGraceDate(optional):
string(date-time)
Title:
Grace Period DateIdentifies the expiration grace date for the application. -
ExpirationStatus(optional):
string
Title:
Expiration StatusMaximum Length:15Identifies the expiration status of the application. -
FeeDueUpdateDate(optional):
string(date-time)
Title:
Fees Due Updated DateIdentifier that captures the date when fee item with due status is added or updated. -
IssueDate(optional):
string(date-time)
Title:
Issue DateThe date the license or planning application was issued. Used in the application information component of the planning application Designer. -
LastUpdateDate(optional):
string(date-time)
Title:
Last Updated DateIdentifies the last update date of the planning application. -
LastUpdatedBy(optional):
string
Title:
Last Updated by User IDMaximum Length:64Identifies the user who last updated the application by the login ID. -
LastUpdatedByName(optional):
string
Title:
Last Updated by NameIdentifies the user name of the person who last updated the application. -
Latitude(optional):
number
The geographic location of the permit parcel that is to the North or South of the equator.
-
links(optional):
array Items
Title:
ItemsLink Relations -
LnpRecordId(optional):
string
Title:
Application IDMaximum Length:50The identifier for the building planning application. For example, a planning application number with a value such as Building planning application ID RA-2017-00029. -
LnpRecordKey(optional):
integer(int64)
The unique identifier for the planning application.
-
Longitude(optional):
number
The geographic location of the permit parcel that is to the East or West of the meridian. It typically points to a specific entrance area within a large permit parcel, for example, a security checkpoint gate, delivery entrance, or employee entrance.
-
OrganizationName(optional):
string
Title:
Business NameMaximum Length:360The business name of the applicant. For example, a contractor enters his or her contracting business name. -
Originator(optional):
string
Title:
OriginatorMaximum Length:3Identifies the originator of the application. -
Owner(optional):
string
Title:
Property Owner NameMaximum Length:150The primary or only owner of the parcel or property. -
OwnerEmailId(optional):
string
Title:
Property Owner EmailMaximum Length:50The parcel owner's email. -
OwnerId(optional):
integer(int64)
The owner ID of the parcel owner.
-
OwnerKey(optional):
integer(int64)
The owner key of the parcel owner.
-
ParcelAddress1(optional):
string
Title:
Property Address Line 1Maximum Length:240The first line of the parcel or property address. -
ParcelAddress2(optional):
string
Title:
Property Address Line 2Maximum Length:240The second line of the parcel or property address. -
ParcelCity(optional):
string
Title:
Property CityMaximum Length:60The city in the parcel or property address. -
ParcelCountry(optional):
string
Title:
Property CountryMaximum Length:60The country in the parcel or property address. -
ParcelCounty(optional):
string
Title:
Property CountyMaximum Length:60The county in the parcel or property address. -
ParcelId(optional):
integer(int64)
Title:
ParcelThe identifier of the record parcel. -
ParcelKey(optional):
integer(int64)
The key of the record parcel.
-
ParcelPostalCode(optional):
string
Title:
Property Postal CodeMaximum Length:60The postal code in the parcel or property address. -
ParcelProvince(optional):
string
Title:
Property ProvinceMaximum Length:60The province in the parcel or property address. -
ParcelState(optional):
string
Title:
Property StateMaximum Length:60The state in the parcel or property address. -
ParcelType(optional):
string
Title:
Parcel TypeMaximum Length:30The type of the current parcel. -
PersonFirstName(optional):
string
Title:
Applicant First NameMaximum Length:150The applicant first name. -
PersonLastName(optional):
string
Title:
Applicant Last NameMaximum Length:150The applicant last name. -
PersonMiddleName(optional):
string
Title:
Applicant Middle NameMaximum Length:60The applicant middle name. -
PersonTitle(optional):
string
Title:
Applicant TitleMaximum Length:60The title of the contact. -
PlanningDescription(optional):
string
Title:
Application DescriptionMaximum Length:300The description of the planning application type. -
PlanningStatus(optional):
string
Title:
Application StatusMaximum Length:100The status of the planning application. -
PrimaryContactEmail(optional):
string
Maximum Length:
320Identifies the email of the primary contact of the application. -
PrimaryContactName(optional):
string
Maximum Length:
450Identifies the primary contact name of the application -
PrimaryContactPartyId(optional):
integer(int64)
Identifies the party ID of the primary contact of the application.
-
PrimaryContactphoneExtension(optional):
string
Maximum Length:
20The extension for the primary contact telephone number. -
PrimaryContactPhoneNumber(optional):
string
Maximum Length:
80Identifies the phone number of the primary contact of the application. -
PrimaryContactType(optional):
string
Maximum Length:
30Identifies the contact type of the primary contact of the application. -
PrimaryContactUserId(optional):
string
Identifies the user ID of the primary contact.
-
ProjectKey(optional):
integer(int64)
The project name information for a planning application.
-
PropertyDescription(optional):
string
Title:
Property DescriptionMaximum Length:240The property description. -
ReceivedDate(optional):
string(date-time)
Title:
Received DateIdentifies the received date of the application. -
RecordStatus(optional):
string
Maximum Length:
15The status of the application. -
RecordType(optional):
string
Title:
Application TypeMaximum Length:100The planning application type. Agencies define the types of planning application that they administer, for example, Residential Addition. -
RecordTypeId(optional):
string
Maximum Length:
30The identifier for a record type. -
RenewalDate(optional):
string(date-time)
Title:
Renewal DateThe renewal date for the license or planning application. -
RowType(optional):
string
Maximum Length:
30The identifier for a record type. -
SecondaryOwner(optional):
string
Title:
Property Secondary OwnerMaximum Length:150The secondary owner of the parcel or property. -
Subclassification(optional):
string
Maximum Length:
10The subclassification of the planning application type. -
SubclassificationMeaning(optional):
string
Title:
SubclassificationMaximum Length:80The description for the subclassification of the planning application type. -
SubmitDate(optional):
string(date-time)
Title:
Submission DateThe date the license and planning application transaction was submitted. Used in the application information component of the planning application Designer. -
SubmittedBy(optional):
string
Title:
Submitted by User IDMaximum Length:64Identifies the user who submitted the application by the login ID. -
SubmittedByName(optional):
string
Title:
Submitted by NameIdentifies the user name of the person who submitted the application. -
SystemStatus(optional):
string
Title:
Application System StatusMaximum Length:15Identifies the system status of the application. -
TotalFees(optional):
number
Title:
Fees Total AmountThe total fees for the application. -
TotalHold(optional):
number
Title:
Fees on HoldIdentifies the total hold fee amount. -
TotalOutstanding(optional):
number
Title:
Fees Outstanding BalanceIdentifies the total outstanding fee amount. -
TotalPaid(optional):
number
Title:
Fees Total PaidThe total fee paid for the application. -
TotalPayable(optional):
number
Title:
Fees Total PayableThe total fee payable for the application. -
TotalPending(optional):
number
Title:
Fees in Pending StatusIdentifies the total pending fee amount. -
TotalWaived(optional):
number
Title:
Fees WaivedIdentifies the total fee waived. -
Url(optional):
string
Title:
URLThe URL for the planning application. -
UrlLabel(optional):
string
Title:
Link to Planning ApplicationThe URL label for the planning application. -
WithdrawalReason(optional):
string
Title:
Withdrawal ReasonMaximum Length:1000Identifies the reason that a planning application was withdrawn. -
WithdrawnByName(optional):
string
Title:
Withdrawn by NameIdentifies the user name of the person who withdrew the application. -
WithdrawnByUserID(optional):
string
Title:
Withdrawn by User IDMaximum Length:64Identifies who withdrew the planning application. -
WithdrawnDate(optional):
string(date-time)
Title:
Withdrawal DateIdentifies the date that the planning application was withdrawn.
Nested Schema : link
Type:
Show Source
object-
href(optional):
string
Title:
hyperlink referenceThe URI to the related resource. -
rel(optional):
string
Title:
relationThe name of the relation to the resource instance. Example: self.