topic Re: Salesforce Extraction on Custom Tables in QlikView

Salesforce Extraction on Custom Tables

Anonymous — Wed, 11 Nov 2015 16:17:37 GMT

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?

Re: Salesforce Extraction on Custom Tables

engishfaque — Thu, 12 Nov 2015 03:47:17 GMT

Dear Dan,

After your Custom Connection "CUSTOM CONNECT TO xxx",

Try this one:

SQL SELECT

FROM Your_Custom_Table_Name

Kind regards,

Ishfaque Ahmed

Re: Salesforce Extraction on Custom Tables

Anonymous — Thu, 12 Nov 2015 14:15:31 GMT

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.

Re: Salesforce Extraction on Custom Tables

engishfaque — Fri, 13 Nov 2015 03:20:49 GMT

Dear Dan,

Please check privileges over the custom table in Salesforce.

Kind regards,

Ishfaque Ahmed

Re: Salesforce Extraction on Custom Tables

Anonymous — Fri, 13 Nov 2015 14:43:41 GMT

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?

Re: Salesforce Extraction on Custom Tables

Anonymous — Tue, 01 Dec 2015 21:55:03 GMT

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.