Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

GetRequest WebService - getRequest of multiple requests

Highlighted
PublicEducation
Super Collector

GetRequest WebService - getRequest of multiple requests

Hello All,

There is great info here about the C# implementation of the getRequests method of the demand management web-service operations.

One question I had was what if I am doing a data dump and need to get the same simple field of multiple requests.

I see a great example of how to loop throw an array of all fields returned from multiple requests.

Any ideas on how to do a requestArray or something similar?
2 REPLIES
PublicEducation
Super Collector

Re: GetRequest WebService - getRequest of multiple requests

For everyone working on this issue I used a workaround:

I used a sql rule in a hidden field in the request type to generate SQL that outputs the request_id's to the field. The rule runs on creation.

NOW, I use the getRequests operation to instantiate a request. WHen the request is created, I then get the simplefields of the request, which holds the output from the sql rule, giving me all the request_id's

Now I assume I can feed this output into another get requests operation and I can loop through each to return the desired fields for each.
PublicEducation
Super Collector

Re: GetRequest WebService - getRequest of multiple requests

see solution above
//Add this to "OnDomLoad" event