How to solve issue with salesforce connector

Question

The previous Salesforce legacy connector allowed SQL queries, which was useful for handling data issues in certain objects. The new connector only supports SOQL queries e.g.,select fields(standard) from xyz ,lacking support for custom field selection or retrieving all fields ( select fields(custom ) from xyz or select fields(all) from xyz).We require the equivalent of select * from xyz but encounter 'outer bounds' errors when using fields(all). field(all ) considered as a unbound and bulk API 2.0 is not support unbounded query.So please suggest any other methods to retrieve all fields using bulk api 2.0

Answer 1

Hi Mayur Patil,

Thanks for reaching out to Microsoft Q&A.

Consider using third party ETL tools(talend) that integrate with Salesforce. These tools often provide more flexibility in querying and can handle the retrieval of all fields without the limitations imposed by the Bulk API. These tools typically allow you to set up data flows that can automatically handle metadata and construct the necessary queries.

(OR)

Try query tooling in salesforce If you have access to Salesforce Developer tools or the Salesforce Workbench. You can leverage these tools to run SOQL queries more interactively. This allows you to test and refine your queries before implementing them in your application.

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

Answer 2

Hi @Mayur Patil
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .
Issue: The previous Salesforce legacy connector allowed SQL queries, which was useful for handling data issues in certain objects. The new connector only supports SOQL queries e.g.,select fields(standard) from xyz ,lacking support for custom field selection or retrieving all fields ( select fields(custom ) from xyz or select fields(all) from xyz).We require the equivalent of select * from xyz but encounter 'outer bounds' errors when using fields(all). field(all ) considered as a unbound and bulk API 2.0 is not support unbounded query.So please suggest any other methods to retrieve all fields using bulk api 2.0
Solution: While we appreciate the bulk API 2.0, we'd prefer to avoid REST APIs. Unfortunately, the current limitations of bulk API 2.0, such as the lack of support for the field(all) and the new connector's restrictions, make it challenging to extract data from our source. To address this, we suggest considering the implementation of SQL commands for the new connector.
If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

I hope this helps!

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.