GetProjectData

Retrieves the most recently submitted data for each data field in the given project form. Requires read access to the project. Returns data from the target form and indicates whether the form is filled out complete enough to be submitted. Request Draft data to get the unsubmitted data located on the form.

Request

GET  /Programs/{ProgramId}/Projects/{ProjectId}/Forms/{FormId}/Data
GET  /Programs/{ProgramId}/Projects/{ProjectId}/Forms/{FormId}/Draft/Data

Path Parameters

Name	Value	Description
`ProgramId`	`string`	Unique identifier for the program.
`ProjectId`	`string`	Unique identifier for the project.
`FormId`	`string`	Unique or custom identifier for the form.

Optional Query Parameters

Name	Value	Description
`reveal_sensitive_data`	`boolean`	Sensitive data is obfuscated by default. To retrieve the plaintext value, set this parameter to “true”. The account making the request must have the appropriate privileges and must have MFA enabled.

Request Body

Do not supply a request body with this method.

Response

Response Body

{
    "Project": {
        "ProjectId": string,
        "ProgramId": string,
        "ProjectNumber": null | string,
        "Url": string,
        "LastChangeTimestamp": datetime,
        "CurrentStatus": {
            "StatusId": string,
            "CustomId": null | string,
            "Name": string,
            "Timestamp": datetime
        },
        "CanSubmit": boolean,
        "DataFields": [
            {
                "DataFieldId": string,
                "CustomId": null | string,
                "Name": string,
                "Value": null | string
                "Values": null | [
                    string
                ]
            }
        ],
        "Attachments": [
            {
                "AttachmentId": string,
                "CustomId": null | string,
                "Name": string,
                "FileName": null | string
            }
        ]
    }
}

{
    "Project": {
        "ProjectId": "231YD3N7RZ1U",
        "ProgramId": "4DYY5AZ862VM",
        "ProjectNumber": "TEST-00001",
        "Url": "http://testagency.powerclerk.com/MvcProjects/LandingPage?ProgramId=4DYY5AZ862VM&ProjectId=231YD3N7RZ1U",
        "LastChangeTimestamp": "2022-11-14T15:15:55-08:00",
        "CurrentStatus": {
            "StatusId": "UTF5UF2KAJ3T",
            "CustomId": null,
            "Name": "Application in Process",
            "Timestamp": "2022-11-14T13:39:53-08:00"
        },
        "CanSubmit": true,
        "DataFields": [
            {
                "DataFieldId": "R2YX21RVSF51",
                "CustomId": null,
                "Name": "Checkbox",
                "Value": "false"
            },
            {
                "DataFieldId": "EXD40E6S9U09",
                "CustomId": null,
                "Name": "Decimal 2",
                "Value": "0.5"
            },
            {
                "DataFieldId": "10SQ28XRTZ9M",
                "CustomId": null,
                "Name": "Single Line Text",
                "Value": "this is text"
            },
            {
                "DataFieldId": "QGF4FF6M6CVZ",
                "CustomId": null,
                "Name": "Table date column",
                "Values": [
                    "2022-11-14",
                    ""
                ]
            }
        ],
        "Attachments": [
            {
                "AttachmentId": "FR7V8ZKF4WH4",
                "CustomId": null,
                "Name": "Attachment Name",
                "FileName": null
            }
        ]
    }
}

<?xml version="1.0"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" attributeFormDefault="unqualified" elementFormDefault="qualified">
  <xs:element name="ProjectDataGetResponse">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="Project">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CurrentStatus">
                <xs:complexType>
                  <xs:attribute type="xs:string" name="StatusId" use="required"/>
                  <xs:attribute type="xs:string" name="CustomId" use="optional"/>
                  <xs:attribute type="xs:string" name="Name" use="required"/>
                  <xs:attribute type="xs:dateTime" name="Timestamp" use="required"/>
                </xs:complexType>
              </xs:element>
              <xs:element name="DataFields">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="DataField" maxOccurs="unbounded" minOccurs="0">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:choice>
                            <xs:element name="Values">
                              <xs:complexType>
                                <xs:sequence>
                                  <xs:element name="Value" maxOccurs="unbounded" minOccurs="0"/>
                                </xs:sequence>
                              </xs:complexType>
                            </xs:element>
                            <xs:element name="Value"/>
                          </xs:choice>
                        </xs:sequence>
                        <xs:attribute type="xs:string" name="DataFieldId" use="required"/>
                        <xs:attribute type="xs:string" name="CustomId" use="optional"/>
                        <xs:attribute type="xs:string" name="Name" use="required"/>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
              <xs:element name="Attachments">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="Attachment" maxOccurs="unbounded" minOccurs="0">
                      <xs:complexType>
                        <xs:attribute type="xs:string" name="AttachmentId" use="required"/>
                        <xs:attribute type="xs:string" name="CustomId" use="optional"/>
                        <xs:attribute type="xs:string" name="Name" use="required"/>
                        <xs:attribute type="xs:string" name="FileName" use="optional"/>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
            <xs:attribute type="xs:string" name="ProjectId" use="required"/>
            <xs:attribute type="xs:string" name="ProgramId" use="required"/>
            <xs:attribute type="xs:string" name="ProjectNumber" use="optional"/>
            <xs:attribute type="xs:string" name="LastChangeTimestamp" use="required"/>
            <xs:attribute type="xs:anyURI" name="Url" use="required"/>
            <xs:attribute type="xs:boolean" name="CanSubmit" use="required"/>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

<?xml version="1.0" encoding="utf-8"?>
<ProjectDataGetResponse>
    <Project ProjectId="231YD3N7RZ1U" ProgramId="4DYY5AZ862VM" ProjectNumber="TEST-00001" Url="http://testagency.powerclerk.com/MvcProjects/LandingPage?ProgramId=4DYY5AZ862VM&ProjectId=231YD3N7RZ1U" LastChangeTimestamp="2022-11-14T15:15:55-08:00" CanSubmit="true">
        <CurrentStatus StatusId="UTF5UF2KAJ3T" Name="Application in Process" Timestamp="2022-11-14T13:39:53-08:00" />
        <DataFields>
            <DataField DataFieldId="R2YX21RVSF51" Name="Checkbox">
                <Value>false</Value>
            </DataField>
            <DataField DataFieldId="EXD40E6S9U09" Name="Decimal 2">
                <Value>0.5</Value>
            </DataField>
            <DataField DataFieldId="10SQ28XRTZ9M" Name="Single Line Text">
                <Value>this is text</Value>
            </DataField>
            <DataField DataFieldId="QGF4FF6M6CVZ" Name="Table date column">
                <Values>
                    <Value>2022-11-14</Value>
                    <Value />
                </Values>
            </DataField>
        </DataFields>
        <Attachments>
            <Attachment AttachmentId="FR7V8ZKF4WH4" Name="Attachment Name" />
        </Attachments>
    </Project>
</ProjectDataGetResponse>

Response Parameters

Name	Value	Description
`Project.ProjectId`	`string`	Unique identifier for the project.
`Project.ProgramId`	`string`	Unique identifier for the program.
`Project.ProjectNumber`	`null` \| `string`	The project number assigned when the project was submitted.
`Project.Url`	`string`	A link to the landing page for the project.
`Project.LastChangeTimestamp`	`datetime`	Timestamp of the last change made to the project in the time zone of the program.
`Project.CanSubmit`	`boolean`	Whether or not the form can be submitted.
`Project.CurrentStatus`	`object`	The current status of the project.
`CurrentStatus.StatusId`	`string`	Unique identifier for the status.
`CurrentStatus.CustomId`	`null` \| `string`	Custom identifier for the status.
`CurrentStatus.Name`	`string`	Name of the status.
`CurrentStatus.Timestamp`	`datetime`	Timestamp of when the project entered the status in the time zone of the program.
`Project.DataFields`	`list`	List of data fields on the form.
`DataFields[].DataFieldId`	`string`	Unique identifier for the data field.
`DataFields[].CustomId`	`null` \| `string`	Custom identifier for the data field.
`DataFields[].Name`	`string`	Name of the data field.
`DataFields[].Value`	`null` \| `string`	Only exists for single-instance fields. Current value of the data field.
`DataFields[].Values`	`null` \| `list`	Only exists for multi-instance fields. List of current values of the data field.
`DataFields[].Values[]`	`string`	Current value of the data field.
`Project.Attachments`	`list`	List of attachments on the form.
`Attachments[].AttachmentId`	`string`	Unique identifier for the attachment field.
`Attachments[].CustomId`	`null` \| `string`	Custom identifier for the attachment field.
`Attachments[].Name`	`string`	Name of the attachment field.
`Attachments[].FileName`	`null` \| `string`	Name of the file uploaded to the attachment field.

Cookie	Duration	Description
CloudFlare CDN	4 weeks	This cookie is set by CloudFare to identify individual clients behind a shared IP address and apply security settings on a per-client basis. It does not correspond to any user ID in the web application and does not store any personally identifiable information.
CookieLawInfo Checkbox Necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category ‘Strictly Necessary’.
CookieLawInfo Checkbox Performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The purpose of this cookie is to check whether or not the user has given the consent to the usage of cookies under the category ‘Performance’.
CookieLawInfo Checkbox Personalization	11 months	This cookie is set by GDPR Cookie Consent plugin. The purpose of this cookie is to check whether or not the user has given the consent to the usage of cookies under the category ‘Enhancements & Personalization’.
Viewed Cookie Policy	1 hour	This cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Website Search Interaction	Session	This cookie is set by Site Search 360, our search engine for all Clean Power Research websites, to record search session preferences and performance.
Website Search Session ID	11 months	This cookie is set by Site Search 360, our search engine for all Clean Power Research websites, to record search session preferences.

Cookie	Duration	Description
Google Analytics Data Limiter	1 minute	This cookie is installed by Google Universal Analytics to throttle the request rate to limit the colllection of data on high traffic sites.
Google Analytics Page Visits	1 day	This cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the wbsite is doing. The data collected including the number visitors, the source where they have come from, and the pages visted in an anonymous form.
Google Analytics Random Identifier	2 years	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site’s analytics report. The cookie stores information anonymously and assigns a randomly generated number to identify unique visitors.
Marketo Tracking	2 years	This cookie is associated with an email marketing service provided by Marketo. This tracking cookie allows the website to link visitor behavior to the recipient of an email marketing campaign, to measure campaign effectiveness.

Cookie	Duration	Description
Wistia Videos	11 months	Set by Wistia to support video functionality that may be found throughout the website. In addition to keeping track of the website visitor's position in a video should playback be interrupted, this cookie also notes user behavior regarding the video itself.
Wistia Videos Data	10 months	This cookie collects visitor interaction data regarding Wistia video content so that such content can be made more relevant to the visitor.

Application & Process Automation V2