Hi, I am a new N8N self hosted user, and wanting to post some data from a filemaker db to a new wordpress post (both hosted on my Synology NAS on a fixed IP). N8N in container manager, filmmaker server in ubuntu VM.
When I set up the connections to both systems, the sign in is successful. Filemaker returns the field I want (a temperature value), but when I try to post to Wordpress as a new post, it fails. As I say, the connection to wordpress works fine.
{
“meta”: {
“templateId”: “1068”,
“instanceId”: “d49e396e1d137f56f20c1bc1e39276422b454cffa6bef3f7fdf94f398521b626”
},
“nodes”: [
{
“parameters”: {},
“name”: “On clicking ‘execute’”,
“type”: “n8n-nodes-base.manualTrigger”,
“position”: [
380,
240
],
“typeVersion”: 1,
“id”: “17e1f1b2-4699-4418-a348-7c81cba1d3e8”
},
{
“parameters”: {
“action”: “records”,
“layout”: “Results”,
“limit”: 1,
“setScriptBefore”: true,
“scriptBefore”: “Sort_descending”
},
“name”: “FileMaker3”,
“type”: “n8n-nodes-base.filemaker”,
“position”: [
580,
240
],
“typeVersion”: 1,
“id”: “26b5482c-935c-4ce9-bf05-eb0948e1d3ed”,
“credentials”: {
“fileMaker”: {
“id”: “9WWjdjEh73wqbgIz”,
“name”: “FileMaker account”
}
}
},
{
“parameters”: {
“title”: “={{ $json.response.data[0].fieldData.Pool }}”,
“additionalFields”: {}
},
“id”: “d4e25d1d-735d-4c99-9898-391df035bfa2”,
“name”: “Wordpress”,
“type”: “n8n-nodes-base.wordpress”,
“typeVersion”: 1,
“position”: [
780,
240
],
“credentials”: {
“wordpressApi”: {
“id”: “ckUy6eawhKufjbfq”,
“name”: “Wordpress account”
}
}
}
],
“connections”: {
“On clicking ‘execute’”: {
“main”: [
[
{
“node”: “FileMaker3”,
“type”: “main”,
“index”: 0
}
]
]
},
“FileMaker3”: {
“main”: [
[
{
“node”: “Wordpress”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {}
}
I get the following error - which is beyond my understanding - I am a basic/intermediate user:
{
“errorMessage”: “Authorization failed - please check your credentials”,
“errorDescription”: “Sorry, you are not allowed to create posts as this user.”,
“errorDetails”: {
“rawErrorMessage”: [
“401 - {"code":"rest_cannot_create","message":"Sorry, you are not allowed to create posts as this user.","data":{"status":401}}”
],
“httpCode”: “401”
},
“n8nDetails”: {
“nodeName”: “Wordpress”,
“nodeType”: “n8n-nodes-base.wordpress”,
“nodeVersion”: 1,
“resource”: “post”,
“operation”: “create”,
“time”: “26/10/2024, 18:10:42”,
“n8nVersion”: “1.64.3 (Self Hosted)”,
“binaryDataMode”: “default”,
“stackTrace”: [
“NodeApiError: Authorization failed - please check your credentials”,
" at Object.requestWithAuthentication (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1305:19)“,
" at processTicksAndRejections (node:internal/process/task_queues:95:5)”,
" at Object.requestWithAuthentication (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:2095:20)“,
" at Object.wordpressApiRequest (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Wordpress/GenericFunctions.js:27:16)”,
" at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Wordpress/Wordpress.node.js:156:40)“,
" at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:722:19)”,
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:711:51",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1141:20"
]
}
}
Hoping someone may either have had a similar issue which they fixed, or that they might understand the error stuff!
Many thanks in advance!