Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist III
Specialist III

Dear Dan,

After your Custom Connection "CUSTOM CONNECT TO xxx",

Try this one:

--

SQL SELECT

*

FROM Your_Custom_Table_Name

Kind regards,

Ishfaque Ahmed

Anonymous
Not applicable
Author

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
Specialist III
Specialist III

Dear Dan,

Please check privileges over the custom table in Salesforce.

Kind regards,

Ishfaque Ahmed

Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

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.