Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Use list of fields instead of * in ReadbyQuery in Sage Intacct connector

Answered
Amit Patkar User

For certain objects like "Compliance" the Sage Intacct connector just times out. Sage support has identified that this is because using "*" as the fields in the "ReadByQuery" API call within the connector causes the connector to fetch data from related entities which takes a very long time. 

There are two suggested fixes:

1. Use the list of fields only on the object in question and not related objects and pass that as a parameter instead of "*" while using the ReadByQuery API call

2. Use a "lookup" API call to get the list of fields and then user the "Query" API call instead of "ReadByQuery" with the list of the fields. "Query" call does not work with "*" as the fields.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Erin Fivetranner

    Hi Amit - 

    Thanks for submitting this feature request. We try to make our connectors as dynamic as possible so a hard coded list of values isn't typically ideal, however we could potentially look into ways to improve the speed and performance of this connector to hopefully solve the issue of timing out. 

    I'll add this to our backlog.

    Best, 

    Erin