1 Reply Latest reply: Feb 20, 2013 1:17 PM by Alessandro Saccone RSS

    Querying Salesforce from QlikView Script

      I am in the midst of a POC and need to prove that I can combine data from Salesforce with data from other sources.  I've been successfuly, but now want to put a Salesforce SOQL query into the script, including relationships.  I have a query that I can execute outside of QlikView, but get a syntax error inside of QlikView.  Here it is:

       

      SELECT Name, (SELECT Name FROM Agreements__r), (SELECT Name FROM Agreement_Products__r)

      FROM Account

      WHERE RecordTypeID = '01230000000t5SFAAY'

      LIMIT 100

       

      Thoughts?