JJJJ

Hi @jereze I couldn't find "type" column to add in account section in our system, perhaps we do not have that in my organization. I guess I will wait for the next version. Thank you very much for your help. I will be looking forward to the next version.

Hi @jereze, I logged in and logged out as you say, then I got the debug report. You can find the link below. https://we.tl/t-aDmhm6yJwT

@jereze It has never worked and when I try to login it gives me an error. You can find the debugger output below again. [2019-04-12 19:23:02][STDERR: input.scriptfilter] 19:23:02 workflow.py:2225 DEBUG Workflow version : 0.0.2 19:23:02 workflow.py:2633 DEBUG Got password : jereze.salesforce:access_token 19:23:02 workflow.py:2633 DEBUG Got password : jereze.salesforce:refresh_token 19:23:02 workflow.py:2633 DEBUG Got password : jereze.salesforce:instance_url 19:23:02 workflow.py:1628 DEBUG Reading settings from `/Users/Ceyhun/Library/Application Support/Alfred 3/Workflow Data/jereze.salesforce/settings.json` ... 19:23:02 workflow.py:2423 DEBUG Set last run version : 0.0.2 19:23:02 workflow.py:2267 DEBUG Workflow finished in 0.101 seconds. [2019-04-12 19:23:03][STDERR: input.scriptfilter] 19:23:02 workflow.py:2225 DEBUG Workflow version : 0.0.2 19:23:02 workflow.py:2633 DEBUG Got password : jereze.salesforce:access_token 19:23:02 workflow.py:2633 DEBUG Got password : jereze.salesforce:refresh_token 19:23:02 workflow.py:2633 DEBUG Got password : jereze.salesforce:instance_url 19:23:02 workflow.py:1628 DEBUG Reading settings from `/Users/Ceyhun/Library/Application Support/Alfred 3/Workflow Data/jereze.salesforce/settings.json` ... 19:23:02 workflow.py:2423 DEBUG Set last run version : 0.0.2 19:23:02 workflow.py:2267 DEBUG Workflow finished in 0.102 seconds. [2019-04-12 19:23:03][ERROR: input.scriptfilter] Code 1: 19:23:03 workflow.py:2225 DEBUG Workflow version : 0.0.2 19:23:03 workflow.py:2633 DEBUG Got password : jereze.salesforce:access_token 19:23:03 workflow.py:2633 DEBUG Got password : jereze.salesforce:refresh_token 19:23:03 workflow.py:2633 DEBUG Got password : jereze.salesforce:instance_url 19:23:03 salesforce_api.py:50 INFO API get call: https://eu26.salesforce.com/services/data/v40.0/search/?q=FIND+{logi}+IN+ALL+FIELDS+RETURNING+Account+(Id%2C+Name%2C+Type)%2C+Contact+(Id%2C+Name%2C+Email)%2C+Opportunity+(Id%2C+Name%2C+StageName%2C+CloseDate)%2C+Lead+(Id%2C+Name)+WITH+METADATA%3D'LABELS'+ 19:23:03 salesforce_api.py:78 INFO 5Aep861JmND5bFIsaeJoNXoXlUVRs_AmYexRCMmImn9vREMKE1G.RFjImnpIzdOc6pgYZWWR9HKk1HfOJxQwkWT 19:23:03 salesforce_api.py:79 INFO API post call: https://login.salesforce.com/services/oauth2/token 19:23:03 salesforce_api.py:84 DEBUG {"error":"invalid_grant","error_description":"expired access/refresh token"} 19:23:03 workflow.py:2243 ERROR API error when refreshing the token (400): {"error":"invalid_grant","error_description":"expired access/refresh token"} Traceback (most recent call last): File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.C0B19BE3-EAF6-495A-A013-653D32CDF126/workflow/workflow.py", line 2236, in run func(self) File "salesforce_search.py", line 136, in main 'q': "FIND {%s} IN ALL FIELDS RETURNING Account (Id, Name, Type), Contact (Id, Name, Email), Opportunity (Id, Name, StageName, CloseDate), Lead (Id, Name) WITH METADATA='LABELS' " % query.replace("\\", "\\\\").replace("'", "\\'") File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.C0B19BE3-EAF6-495A-A013-653D32CDF126/salesforce_api.py", line 52, in api_call self.refresh_access_token() File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.C0B19BE3-EAF6-495A-A013-653D32CDF126/salesforce_api.py", line 85, in refresh_access_token raise ValueError('API error when refreshing the token (%i): %s' % (r.status_code, r.text)) ValueError: API error when refreshing the token (400): {"error":"invalid_grant","error_description":"expired access/refresh token"} 19:23:03 workflow.py:2267 DEBUG Workflow finished in 0.604 seconds. [2019-04-12 19:23:04][ERROR: input.scriptfilter] Code 1: 19:23:04 workflow.py:2225 DEBUG Workflow version : 0.0.2 19:23:04 workflow.py:2633 DEBUG Got password : jereze.salesforce:access_token 19:23:04 workflow.py:2633 DEBUG Got password : jereze.salesforce:refresh_token 19:23:04 workflow.py:2633 DEBUG Got password : jereze.salesforce:instance_url 19:23:04 salesforce_api.py:50 INFO API get call: https://eu26.salesforce.com/services/data/v40.0/search/?q=FIND+{login}+IN+ALL+FIELDS+RETURNING+Account+(Id%2C+Name%2C+Type)%2C+Contact+(Id%2C+Name%2C+Email)%2C+Opportunity+(Id%2C+Name%2C+StageName%2C+CloseDate)%2C+Lead+(Id%2C+Name)+WITH+METADATA%3D'LABELS'+ 19:23:04 salesforce_api.py:78 INFO 5Aep861JmND5bFIsaeJoNXoXlUVRs_AmYexRCMmImn9vREMKE1G.RFjImnpIzdOc6pgYZWWR9HKk1HfOJxQwkWT 19:23:04 salesforce_api.py:79 INFO API post call: https://login.salesforce.com/services/oauth2/token 19:23:04 salesforce_api.py:84 DEBUG {"error":"invalid_grant","error_description":"expired access/refresh token"} 19:23:04 workflow.py:2243 ERROR API error when refreshing the token (400): {"error":"invalid_grant","error_description":"expired access/refresh token"} Traceback (most recent call last): File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.C0B19BE3-EAF6-495A-A013-653D32CDF126/workflow/workflow.py", line 2236, in run func(self) File "salesforce_search.py", line 136, in main 'q': "FIND {%s} IN ALL FIELDS RETURNING Account (Id, Name, Type), Contact (Id, Name, Email), Opportunity (Id, Name, StageName, CloseDate), Lead (Id, Name) WITH METADATA='LABELS' " % query.replace("\\", "\\\\").replace("'", "\\'") File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.C0B19BE3-EAF6-495A-A013-653D32CDF126/salesforce_api.py", line 52, in api_call self.refresh_access_token() File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.C0B19BE3-EAF6-495A-A013-653D32CDF126/salesforce_api.py", line 85, in refresh_access_token raise ValueError('API error when refreshing the token (%i): %s' % (r.status_code, r.text)) ValueError: API error when refreshing the token (400): {"error":"invalid_grant","error_description":"expired access/refresh token"} 19:23:04 workflow.py:2267 DEBUG Workflow finished in 0.558 seconds.

Hello @jereze , This workflow might be very useful for me but I get an error when I use the workflow, debugger output is below. What can I do to make it work? Starting debug for 'Salesforce' [2019-04-12 17:03:33][STDERR: input.scriptfilter] 17:03:32 workflow.py:2225 DEBUG Workflow version : 0.0.2 17:03:32 workflow.py:2633 DEBUG Got password : jereze.salesforce:access_token 17:03:32 workflow.py:2633 DEBUG Got password : jereze.salesforce:refresh_token 17:03:32 workflow.py:2633 DEBUG Got password : jereze.salesforce:instance_url 17:03:32 workflow.py:1628 DEBUG Reading settings from `/Users/Ceyhun/Library/Application Support/Alfred 3/Workflow Data/jereze.salesforce/settings.json` ... 17:03:32 workflow.py:2423 DEBUG Set last run version : 0.0.2 17:03:32 workflow.py:2267 DEBUG Workflow finished in 0.117 seconds. [2019-04-12 17:03:36][STDERR: input.scriptfilter] 17:03:35 workflow.py:2225 DEBUG Workflow version : 0.0.2 17:03:35 workflow.py:2633 DEBUG Got password : jereze.salesforce:access_token 17:03:35 workflow.py:2633 DEBUG Got password : jereze.salesforce:refresh_token 17:03:35 workflow.py:2633 DEBUG Got password : jereze.salesforce:instance_url 17:03:35 workflow.py:1628 DEBUG Reading settings from `/Users/Ceyhun/Library/Application Support/Alfred 3/Workflow Data/jereze.salesforce/settings.json` ... 17:03:35 workflow.py:2423 DEBUG Set last run version : 0.0.2 17:03:35 workflow.py:2267 DEBUG Workflow finished in 0.099 seconds. [2019-04-12 17:03:38][ERROR: input.scriptfilter] Code 1: 17:03:36 workflow.py:2225 DEBUG Workflow version : 0.0.2 17:03:36 workflow.py:2633 DEBUG Got password : jereze.salesforce:access_token 17:03:36 workflow.py:2633 DEBUG Got password : jereze.salesforce:refresh_token 17:03:36 workflow.py:2633 DEBUG Got password : jereze.salesforce:instance_url 17:03:36 salesforce_api.py:50 INFO API get call: https://eu26.salesforce.com/services/data/v40.0/search/?q=FIND+{12}+IN+ALL+FIELDS+RETURNING+Account+(Id%2C+Name%2C+Type)%2C+Contact+(Id%2C+Name%2C+Email)%2C+Opportunity+(Id%2C+Name%2C+StageName%2C+CloseDate)%2C+Lead+(Id%2C+Name)+WITH+METADATA%3D'LABELS'+ 17:03:38 salesforce_api.py:78 INFO 5Aep861JmND5bFIsaeJoNXoXlUVRs_AmYexRCMmImn9vREMKE1G.RFjImnpIzdOc6pgYZWWR9HKk1HfOJxQwkWT 17:03:38 salesforce_api.py:79 INFO API post call: https://login.salesforce.com/services/oauth2/token 17:03:38 salesforce_api.py:84 DEBUG {"error":"invalid_grant","error_description":"expired access/refresh token"} 17:03:38 workflow.py:2243 ERROR API error when refreshing the token (400): {"error":"invalid_grant","error_description":"expired access/refresh token"} Traceback (most recent call last): File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.B19691F4-ECEA-46E6-85BC-0ED7E746B876/workflow/workflow.py", line 2236, in run func(self) File "salesforce_search.py", line 136, in main 'q': "FIND {%s} IN ALL FIELDS RETURNING Account (Id, Name, Type), Contact (Id, Name, Email), Opportunity (Id, Name, StageName, CloseDate), Lead (Id, Name) WITH METADATA='LABELS' " % query.replace("\\", "\\\\").replace("'", "\\'") File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.B19691F4-ECEA-46E6-85BC-0ED7E746B876/salesforce_api.py", line 52, in api_call self.refresh_access_token() File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.B19691F4-ECEA-46E6-85BC-0ED7E746B876/salesforce_api.py", line 85, in refresh_access_token raise ValueError('API error when refreshing the token (%i): %s' % (r.status_code, r.text)) ValueError: API error when refreshing the token (400): {"error":"invalid_grant","error_description":"expired access/refresh token"} 17:03:38 workflow.py:2267 DEBUG Workflow finished in 1.966 seconds. [2019-04-12 17:03:40][ERROR: input.scriptfilter] Code 1: 17:03:38 workflow.py:2225 DEBUG Workflow version : 0.0.2 17:03:38 workflow.py:2633 DEBUG Got password : jereze.salesforce:access_token 17:03:38 workflow.py:2633 DEBUG Got password : jereze.salesforce:refresh_token 17:03:38 workflow.py:2633 DEBUG Got password : jereze.salesforce:instance_url 17:03:38 salesforce_api.py:50 INFO API get call: https://eu26.salesforce.com/services/data/v40.0/search/?q=FIND+{12345}+IN+ALL+FIELDS+RETURNING+Account+(Id%2C+Name%2C+Type)%2C+Contact+(Id%2C+Name%2C+Email)%2C+Opportunity+(Id%2C+Name%2C+StageName%2C+CloseDate)%2C+Lead+(Id%2C+Name)+WITH+METADATA%3D'LABELS'+ 17:03:40 salesforce_api.py:78 INFO 5Aep861JmND5bFIsaeJoNXoXlUVRs_AmYexRCMmImn9vREMKE1G.RFjImnpIzdOc6pgYZWWR9HKk1HfOJxQwkWT 17:03:40 salesforce_api.py:79 INFO API post call: https://login.salesforce.com/services/oauth2/token 17:03:40 salesforce_api.py:84 DEBUG {"error":"invalid_grant","error_description":"expired access/refresh token"} 17:03:40 workflow.py:2243 ERROR API error when refreshing the token (400): {"error":"invalid_grant","error_description":"expired access/refresh token"} Traceback (most recent call last): File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.B19691F4-ECEA-46E6-85BC-0ED7E746B876/workflow/workflow.py", line 2236, in run func(self) File "salesforce_search.py", line 136, in main 'q': "FIND {%s} IN ALL FIELDS RETURNING Account (Id, Name, Type), Contact (Id, Name, Email), Opportunity (Id, Name, StageName, CloseDate), Lead (Id, Name) WITH METADATA='LABELS' " % query.replace("\\", "\\\\").replace("'", "\\'") File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.B19691F4-ECEA-46E6-85BC-0ED7E746B876/salesforce_api.py", line 52, in api_call self.refresh_access_token() File "/Users/Ceyhun/Library/Application Support/Alfred 3/Alfred.alfredpreferences/workflows/user.workflow.B19691F4-ECEA-46E6-85BC-0ED7E746B876/salesforce_api.py", line 85, in refresh_access_token raise ValueError('API error when refreshing the token (%i): %s' % (r.status_code, r.text)) ValueError: API error when refreshing the token (400): {"error":"invalid_grant","error_description":"expired access/refresh token"} 17:03:40 workflow.py:2267 DEBUG Workflow finished in 1.641 seconds.