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’