We have a local 8n8 (docker) installation and a local erpnext 15.17.1 installation.
The both work fine and 8n8 is getting data form other sources.
Now we would like to integrate the ERP next API but are unable to connect to the local ERPNext instance.
The following has been done:
Check API with browser as logged-in user. → Works
Generated the API key and secret with system user → done
Setup the connector based on the documentation → Fail.
ERPNext | n8n Docs
We are getting the following errors:
{
“errorMessage”: “Forbidden - perhaps check your credentials?”,
“errorDescription”: “{"exception":"frappe.exceptions.PermissionError","exc_type":"PermissionError","exc":"[\"Traceback (most recent call last):\\n File \\\"apps/frappe/frappe/app.py\\\", line 110, in application\\n response = frappe.api.handle(request)\\n File \\\"apps/frappe/frappe/api/init.py\\\", line 49, in handle\\n data = endpoint(**arguments)\\n File \\\"apps/frappe/frappe/api/v1.py\\\", line 27, in document_list\\n return frappe.call(frappe.client.get_list, doctype, **frappe.form_dict)\\n File \\\"apps/frappe/frappe/init.py\\\", line 1716, in call\\n return fn(*args, **newargs)\\n File \\\"apps/frappe/frappe/utils/typing_validations.py\\\", line 31, in wrapper\\n return func(*args, **kwargs)\\n File \\\"apps/frappe/frappe/client.py\\\", line 67, in get_list\\n return frappe.get_list(**args)\\n File \\\"apps/frappe/frappe/init.py\\\", line 1980, in get_list\\n return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)\\n File \\\"apps/frappe/frappe/model/db_query.py\\\", line 115, in execute\\n self.check_read_permission(self.doctype, parent_doctype=parent_doctype)\\n File \\\"apps/frappe/frappe/model/db_query.py\\\", line 510, in check_read_permission\\n self._set_permission_map(doctype, parent_doctype)\\n File \\\"apps/frappe/frappe/model/db_query.py\\\", line 516, in _set_permission_map\\n frappe.has_permission(\\n File \\\"apps/frappe/frappe/init.py\\\", line 1041, in has_permission\\n raise frappe.PermissionError\\nfrappe.exceptions.PermissionError\\n\"]","_server_messages":"[\"{\\\"message\\\": \\\"User Guest does not have doctype access via role permission for document DocType\\\", \\\"title\\\": \\\"Message\\\"}\"]","_error_message":"No permission for DocType"}”,
“errorDetails”: {
“httpCode”: “rejected”
},
“n8nDetails”: {
“nodeName”: “Erpnext2”,
“nodeType”: “n8n-nodes-base.httpRequest”,
“nodeVersion”: 4.2,
“itemIndex”: 0,
“time”: “22.4.2024, 16:54:42”,
“n8nVersion”: “1.37.3 (Self Hosted)”,
“binaryDataMode”: “default”,
“stackTrace”: [
“NodeApiError: Forbidden - perhaps check your credentials?”,
" at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/HttpRequest/V3/HttpRequestV3.node.js:1571:35)“,
" at processTicksAndRejections (node:internal/process/task_queues:95:5)”,
" at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:728:19)“,
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:660:53”,
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1062:20"
]
}
}
Does anyone expirance the same issues or can someone post his connections to local ERPNext installation?