2 Replies Latest reply: Sep 16, 2015 5:00 AM by Marcus Sommer RSS

    Using variables in FROM clause

    oliver clements

      I am trying to loop through a list of users and pull Web Service data for each.

       

      I have a list of IDs in a table. Field name is "UserID"

       

      I am trying to do something like this:

       

      FOR Each LnID in UserID

      Concatenate Users:

      Load *

      FROM [http://hrapps//humanresources/hrwebservice/emplogin.asmx/Search?LanID= $(LnID)] (XmlSimple, Table is [DataSet]);

       

      is this possible? any advise from pulling all data from ASMX is also appreciated.