topic Getting SalesForce.com data via Qlikview Script in QlikView

Getting SalesForce.com data via Qlikview Script

Sat, 07 Feb 2015 00:13:28 GMT

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

johnca — Sat, 07 Feb 2015 15:53:21 GMT

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