Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Dear Dan,
After your Custom Connection "CUSTOM CONNECT TO xxx",
Try this one:
--
SQL SELECT
*
FROM Your_Custom_Table_Name
Kind regards,
Ishfaque Ahmed
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.
Dear Dan,
Please check privileges over the custom table in Salesforce.
Kind regards,
Ishfaque Ahmed
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?
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.