1 Reply Latest reply: Feb 7, 2015 10:53 AM by John Cavoulas RSS

    Getting SalesForce.com data via Qlikview Script

      I'm connected to SalesForce.com via the Custom Connect API and I'm running the script below.   I see rows being pulled for both SQL statements when executing the script.  However, no data is stored in the output file, and no data appears in a TableBox object.  Where the heck did the data go?      Thanks,   Dan

       

       

      Test1:

       

      Load Account__c as AccountId,
      BAN__c,
      Id,
      Name,
      Tax_ID__c;
      SQL SELECT Account__c,
      BAN__c,
      Id,
      Name,
      Tax_ID__c
      FROM Account_BAN_Tax_ID__c;

      Test2:
      Inner Join

      Load *,
      Id as AccountId;

      SQL SELECT BANs__c,
      Id,
      LastActivityDate,
      Total_Sims__c
      FROM Account
      WHERE Id In (Select Account__c From Account_BAN_Tax_ID__c);

      Store Test1 into L:\SalesServiceFinancialAnalytics\FinanceAnalytics\Sales_Analytics\DMagnus\Qlikview\Test1.csv(txt);

       


       

        • Re: Getting SalesForce.com data via Qlikview Script
          John Cavoulas

          Hi Dan,

           

          I mimicked your script and had success getting Case and Account data. I'm using QV 11.2 SR6 and connector version 12 with url to force API version 30.0. I only limited my data to the last 30 days though. I would say that its possible your Id field 'Account__c' in 'Account_BAN_Tax_ID__c' isn't? Make sure they are. Check to see if they're 15 or 18 characters.

           

          HTH,

          John

           

          Here's my code;

           

          Test1:

          LOAD AccountId,

            CaseNumber,

            Description,

            Subject,

            Category__c,

            Type_Level_2__c,

            Area_Level_3__c;

           

          SELECT AccountId,

            CaseNumber,

            Description,

            Subject,

            Category__c,

            Type_Level_2__c,

            Area_Level_3__c

          FROM Case

          Where CreatedDate = LAST_N_DAYS:30;

           

          Test2:

          Inner Join

          LOAD

            Id as AccountId,

            Name,

            District__c;

           

          SELECT Id,

            Name,

            District__c

          FROM Account

          Where Id In (Select AccountId From Case);