Is it possible to retrieve/display multiple columns in a single web request?


Badge +1

For example, if I want to make a web request based on a user id and need the associated last name, first name, phone, and dept id, do I need to use 4 web request controls with an identical Service URL to get the 4 different columns?


2 replies

Badge +7

Hello George,

Can you elaborate your question and include your exact requirement if possible.

But yes, with single web request we can return multiple values in general.

Badge +1

Thanks Soni, I'll try to elaborate. Using web services with MS InfoPath can generate a data source that depending on the query will return 0, 1, or multiple rows. So with a single query, multiple rows be presented in a repeating table, or if a single row is returned can be used to populate multiple fields in the form.

It looks like a particular web request control can only be configured to return values for a single column. Is there a way using a single web request to assign multiple columns be returned and values populated into their corresponding fields?

Reply