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.

Make sure ERPNext Credentials are correct.

@anupam.vs

i have reseted the credentials mutliple times. if i enter the credentials they get accepted.

please check the error messages in my post from 12.09.

Have you verified that the api endpoints and credentials you’re trying to use are working correctly using curl/postman?

From the n8n side, there’s not much we can do to help you. Those error messages don’t mean much to us here. For what it’s worth, n8n is working fine with my site.

Lets connect to look into this issue?

Endpoint should not contain /app. It should be something like https://demo.logedo.com