Vantagepoint REST Queries

This page will show a number of default Vantagepoint API queries for different scenarios. These queries can also be used with the new PassThrough Connector Project (documentation here)

If you want to see more queries please comment on this site and I will try to add as many as I can. At this point I’m focusing on GET commands

Hub Queries

A simple project hub query with a limit of 10 entries:

project?limit=10

An employee query that returns a limited set of fields (Id, First and Last Name)

employee?limit=100&fieldfilter=Employee%2CFirstName%2CLastName

A project query with a limit and a “filter hash”

project?limit=10&wbstype=wbs1&fieldFilter=WBS1%2cName%2cLongName&filterHash[0][seq]=1&filterHash[0][name]=ChargeType&filterHash[0][value]=R&filterHash[0][tablename]=PR&filterHash[0][type]=dropdown&filterHash[0][opp]=%3d&filterHash[0][condition]=&filterHash[0][searchlevel]=1&filterHash[1][seq]=2&filterHash[1][name]=ProjectType&filterHash[1][value]=07&filterHash[1][tablename]=PR&filterHash[1][type]=dropdown&filterHash[1][opp]=%3d&filterHash[1][condition]=&filterHash[1][searchlevel]=1

This query contains two so called filter hashes that allow you to specify query conditions. All conditions with [filterhash][0] belong to the first condition and all with [filterhash][1] to the second.

First Condition: PR.ChargeType = ‘R’

Second Condition: PR.ProjectType = ’07’

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.