Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
johnca
Specialist
Specialist

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