Taking Too long in Execution salesforce

robin_singh · October 22, 2020, 8:26am

I am trying to integrate workflow with salesforce and Get All leads with limit of 1 (31 records in a page).But it takes too much time in execution. I have total of 713 records so I think it gets all records in front and apply limit on frontend.

So please help in decrease the execution time.

jan · October 22, 2020, 8:33am

Welcome to the community @robin_singh!

It should actually already work as you described. It applies the limit directly when making the request. Here is the code, you can see it in the line 873

github.com

n8n-io/n8n/blob/master/packages/nodes-base/nodes/Salesforce/Salesforce.node.ts#L873

      
        
            				for (const field of fields) {
            					const fieldName = field.label;
            					const fieldId = field.name;
            					returnData.push({
            						name: fieldName,
            						value: fieldId,
            					});
            				}
            				sortOptions(returnData);
            				return returnData;
            			},
            			// Get all the attachment fields recurrence instances to display them to user so that he can
            			// select them easily
            			async getAtachmentFields(this: ILoadOptionsFunctions): Promise<INodePropertyOptions[]> {
            				const returnData: INodePropertyOptions[] = [];
            				// TODO: find a way to filter this object to get just the lead sources instead of the whole object
            				const { fields } = await salesforceApiRequest.call(this, 'GET', `/sobjects/attachment/describe`);
            				for (const field of fields) {
            					const fieldName = field.label;
            					const fieldId = field.name;
            					returnData.push({