Dynamically specify data in Credentials

I’m trying to specifiy the host in credentials FilewMaker node dynamically.
I’m specifiying the node and the json path like this:
{{ $('GetFMServer').item.json["response"]["data"][0]["fieldData"]["Host"] }}
I can see below the expression the Host data is found and it shows me the result.

However attempting to execute the node:

ERROR: Can’t get data for expression under ‘Could not find parameter "undefined"’ field
Apologies, this is an internal error. See details for more information
Missing sourceData (probably an internal error)

and a popup:

Problem in node ‘MyNode‘
Can’t get data for expression [Error resolving credentials]
  • n8n version: 1.18.0

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Hi @MickCrozier :wave: Thanks for getting in touch, and sorry it has taken so long! Welcome to the community :tada:

Could you share your workflow with us so we can see what might be happening? For example, depending on where the FileMaker node is after you’ve either pulled in or set the credentials previously, you might have to change the structure of your expression. You can see an example of this in this post here: Problem in node ‘SSH‘ Can’t get data for expression [Error resolving credentials]

Let me know if that was the issue, and if not, share your workflow with us so we can take a peek :+1:

1 Like

Hi @EmeraldHerald

Pretty sure I’ve got the order right…
Here’s a screen shot of the flow

Here’s the result of the GetFMServer node:
(This matches the Jira Board, to the correct FileMaker Host and Database)

[
    {
        "response": {
            "dataInfo": {
                "database": "JiraIntegration",
                "layout": "ProjectToHost",
                "table": "ProjectToHost",
                "totalRecordCount": 1,
                "foundCount": 1,
                "returnedCount": 1
            },
            "data": [
                {
                    "fieldData": {
                        "__PK": "CFF98A60-65EF-4B37-8ED6-724F47B6AE79",
                        "ProjectID": "10018",
                        "Host": "<REMOVED>",
                        "Database": "JiraIntegration"
                    },
                    "portalData": {},
                    "recordId": "1",
                    "modId": "2"
                }
            ]
        },
        "messages": [
            {
                "code": "0",
                "message": "OK"
            }
        ]
    }
]

In the ‘FM Find Issue’ node - here’s the credentials screen.
It’s giving me the expected values for both Host and Database.
Screenshot 2024-01-22 at 2.51.12 pm

However trying to execute the node (or even set it up properly) doesn’t work as the credentials cause an error:

Hi @MickCrozier :wave: Thanks for sharing that - I’m not too sure if this will fix this up, but could you try upgrading to our latest version? It might at least provide a more helpful error :see_no_evil:

1 Like

ah well, don’t I feel silly.
Update did the trick, all working as expected now!

Thanks @EmeraldHerald

Glad that fixed it up for you! :smiley:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.