Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

danmercer
Contributor

Salesforce Extraction on Custom Tables

Hi All,

I'm trying to pull data from a custom Salesforce table, but it continues to come back with zero rows.  We've tested out my login with the Salesforce Data Loader, and it seems to show everything that you would expect.

It's only this one table.  I'm still able to get information for every other table.

Any Thoughts?  What other details can I provide?

5 Replies
engishfaque
Valued Contributor III

Re: Salesforce Extraction on Custom Tables

Dear Dan,

After your Custom Connection "CUSTOM CONNECT TO xxx",

Try this one:

--

SQL SELECT

*

FROM Your_Custom_Table_Name

Kind regards,

Ishfaque Ahmed

danmercer
Contributor

Re: Salesforce Extraction on Custom Tables

Ishafaque,

I'm extracting data from multiple tables in the same QVW.  The custom table is the only one that is showing up with zero rows.  It's not returning any errors, it's simply showing that there is no data in the table.  We know that is not the case as we've looked with the Salesforce Data Loader. 

To me, this means that it's not likely a problem with the script. Actually the script is the same for all tables, and I've simply changed the table name.

engishfaque
Valued Contributor III

Re: Salesforce Extraction on Custom Tables

Dear Dan,

Please check privileges over the custom table in Salesforce.

Kind regards,

Ishfaque Ahmed

danmercer
Contributor

Re: Salesforce Extraction on Custom Tables

Ishfaque Ahmed,


I checked those with the salesforce admin before posting here. Using the Saleforce Data Loader with my login and security token I was able to see that I have full access to the table.


Also - wouldn't the extraction show an error if I didn't have access, rather than only showing a return of 0?

danmercer
Contributor

Re: Salesforce Extraction on Custom Tables

Still looking for an answer on this problem.  I can clearly access the table, as I'm able to pull in the fields, it's simply saying that the fields are blank.