Running a query of salesforce records, need opportunities, accounts and contacts so that I can feed into agent to take actions. I can’t even get past the 2nd query because it hangs forever, when I limit to 1 execution it’s quick anything more and it’s taking minutes (which doesn’t make sense).
Is there a way to make this step of multiple queries in salesforce faster to handle a large volume of records?
It took 5 minutes to execute 50. I’m on trial, is it faster when we pay for it?
Is there any reason why you are using “get many”. According to me the output of node 1 would be a long list with items. as every customer has a specific id. you should be able to iterate over the them by requesting less data / or only for that one. IMHO you should use get account / instead of get accounts. Regarding upgrading your cloud plan, I’m not really sure but the workflow is simple and i think the delay mostly comes from the API delays of salesforce. you could do a test run limiting to 1 record or 10. measure how much time it takes and see how many you have to process each day. from that you get an estimate of what the min. time required would be.
I think that’s what I need to change, was trying to save on executions. Want to use it with an agent to be a smart data steward to start but refine to surface and reach out to leads as it advances.