Salesforce Organization Table not returning any records
Posted: Fri 01 May 2020 20:08
We are developing an application that needs to read every table in a Salesforce organization. This is quite successful in both reading the structure of the tables (via various system tables) and all of the data records for interesting tables. We automatically check for and eliminate those "extraneous" fields that have definitions in the system tables, but are not really part of the actual table records (for example, if a label is changed in a table....that label is reported as a field in the Sys_Columns table).
However, we are encountering an odd symptom with the "Organization" table. Even after excluding those fields that are not 'real', and also (as an experiment) manually excluding the "Address" field since it is a compound field, we are not getting any query errors. However, the returned data set does not have any information.
Your DemoCenter example is capable of getting the record field data and so is RazorSql. However, both of these take multiple seconds. We extended the connection timeout to over 60 seconds with no joy. At the same time, we are not having any issues with reading other large tables with over 150 Fields and in excess of 600,000 records.
Any thoughts?
However, we are encountering an odd symptom with the "Organization" table. Even after excluding those fields that are not 'real', and also (as an experiment) manually excluding the "Address" field since it is a compound field, we are not getting any query errors. However, the returned data set does not have any information.
Your DemoCenter example is capable of getting the record field data and so is RazorSql. However, both of these take multiple seconds. We extended the connection timeout to over 60 seconds with no joy. At the same time, we are not having any issues with reading other large tables with over 150 Fields and in excess of 600,000 records.
Any thoughts?