PlanviewEnterprise.CallQueryService

PlanviewEnterprise.CallQueryService

Enter the URL, database name associated with your Enterprise One - Portfolio and Resource Management account and a SQL query.

function (url as text, database as text, sqlQueryString as text) as table

Description

Returns a table with Enterprise One - Portfolio and Resource Management data.

Category

Accessing data

Examples

Returns a table with Enterprise One - Portfolio and Resource Management data.

PlanviewEnterprise.CallQueryService("https://contoso.com/planview", "pve", "select * from PV_Table")

A table of Enterprise One - Portfolio and Resource Management data about database pve