API Access with n8n

Hi,

i really love ERPNext so far.

right now i am trying to connect our Ticket system Zammad using n8n.

The API credentials get accepted but it does not display any DocType.

i looked up how to check logs for API calls link#

i am not sure where to enter these commands.

ERPNext is installed on a Ubuntu Host

n8n ist running in Docker.

My Versions are

iERPNext: v14.0.2 (version-14)

Frappe Framework: v14.4.1 (version-14)

n8n Version 0.193.3

Best Regards

It works for me, but I’m on v13. Do you have any error messages? Maybe that could help…

hi @Monolithon,

sadly i don’t get any error message only doctypes are missing:

image

i used this Guide to install ERPNext.

maybe someone can point me out how to generate the logs for API. I checked this but i dont get where to enter these commands.

now i tried it with a http request and i am getting some errors now

when refering to http://192.168.200.216/app. this should be the right domain. When entering the API credentials in n8n it confirmed them to be working. this is also the url i can access ERPNext directly.

Error

HTTP Code

rejected

Cause
Data below may contain sensitive information. Proceed with caution when sharing.

{

“status”: “rejected”,

“reason”: {

“message”: “404 - “\n\n404 Not Found\n\n

Not Found

\n

The requested URL was not found on this server.

\n
\nApache/2.4.38 (Debian) Server at 192.168.200.216 Port 80\n\n””,

“name”: “Error”,

“stack”: “Error: Request failed with status code 404 at createError (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/createError.js:16:15) at settle (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/settle.js:17:12) at IncomingMessage.handleStreamEnd (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/adapters/http.js:269:11) at IncomingMessage.emit (node:events:525:35) at endReadableNT (node:internal/streams/readable:1358:12) at processTicksAndRejections (node:internal/process/task_queues:83:21)”

}

}

Stack

NodeApiError: UNKNOWN ERROR - check the detailed error for more information
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/HttpRequest/HttpRequest.node.js:1025:27)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/src/Workflow.js:598:28)
    at async /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/src/WorkflowExecute.js:557:53

if i change to http://192.168.200.216/

Error

HTTP Code

rejected

Cause
Data below may contain sensitive information. Proceed with caution when sharing.

{

“status”: “rejected”,

“reason”: {

“message”: “503 - {“code”:503,“success”:false,“message”:“API server disabled”,“time”:0}”,

“name”: “Error”,

“stack”: “Error: Request failed with status code 503 at createError (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/createError.js:16:15) at settle (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/settle.js:17:12) at IncomingMessage.handleStreamEnd (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/adapters/http.js:269:11) at IncomingMessage.emit (node:events:525:35) at endReadableNT (node:internal/streams/readable:1358:12) at processTicksAndRejections (node:internal/process/task_queues:83:21)”

}

}

Stack

NodeApiError: UNKNOWN ERROR - check the detailed error for more information
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/HttpRequest/HttpRequest.node.js:1025:27)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/src/Workflow.js:598:28)
    at async /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/src/WorkflowExecute.js:557:53

Let me share a workable example for you, maybe you got some idea:

1 Like

Thank you for your reply.

check my post before i just cant select the DocType because there are none listed.

Someone with knowlege how the API works should please check the error logs in my previous post.