You can retrieve 3 different lists of projects from Pruvan. A list of all the projects in the Project table; a list of the projects in the projects table from a specified date; or a list of all projects that have been touched in the last 90 days, from the Projects or Photos tables.
URL
GET https://www.direct.pruvan.com/beta/content/manual-integration/export.html
Query Parameters
Format
This should always be set to 'csv' to have a file returned in the response, otherwise you will get HTML back. Default is 'html'.
?format=csv
Extra
This allows you to select which list of projects you want to retrieve. Set to '1' to get the past 90 days list. Default is '0'; project table only.
&extra=1
Tz
This is the timezone offset. This is only used when extra=1, and only effects the time reported in the First Photo and Last Photo columns. This is set in minutes; ie CST = 6 hrs from UTC = 360 minutes. The default is Central Time, Standard (360) or Daylight (300) depending.
&tz=300
Last Update
This allows you to specify a last updated date for projects from the project table. This will only pull data that has been updated on or after the specified date. Format is yyyy-mm-dd, ie 2015-12-31. The default is all orders. This will not work with extra=1, in the event extra is set then this field will be ignored.
&lastUpdate=2015-08-10
Full Example
https://www.direct.pruvan.com/v2/content/manual-integration/export.html?format=csv&extra=1&tz=300&lastUpdate=2018-08-10
cURL Example
curl -b pruvan.cookie https://www.direct.pruvan.com/v2/content/manual-integration/export.html?format=csv&extra=1&tz=300&lastUpdate=2018-08-10
Authentication
You must have an authenticated session to use this service.
Role Restrictions
This service is not available to the Crew user role.
Comments