Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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);


1 Reply
johncaqc
Valued Contributor

Re: Getting SalesForce.com data via Qlikview Script

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);

Community Browser