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.