Retable - Update Row API

Describe the problem/error/question

Im getting error when trying to update a row in Retable using their API. im getting the error when im trying to reference a variable that is outputed by the previous node.

here is my body of the http request that updates the row:

“rows”: [
“row_id”: 1,
“columns”: [
“column_id”: “wTmZwW6tb7wsVX54”,
“update_cell_value”: “{{ $(‘Enrich Profile’) }}”

What is the error message (if any)?

1 item

ERROR: Can’t get data for expression under ‘JSON’ field

In node ‘undefined’, output item 0 points to an input item on node ‘User Does Not Exist ?‘ that doesn’t exist.



7/21/2023, 11:33:44 AM

Item Index: 0 | In or underneath Parameter: JSON

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

"={ “rows”: [ { “row_id”: 1, “columns”: [ { “column_id”: “wTmZwW6tb7wsVX54”, “update_cell_value”: “{{ $(‘Enrich Profile’) }}” } ] } ] } "


ExpressionError: Can’t get data for expression
    at createExpressionError (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:453:20)
    at getPairedItem (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:490:27)
    at pairedItemMethod (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:714:40)
    at Object.get (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowDataProxy.js:717:40)
    at Proxy.eval (eval at _create (/usr/local/lib/node_modules/n8n/node_modules/@n8n_io/riot-tmpl/dist/tmpl.js:388:14), <anonymous>:3:300)
    at Proxy.eval (eval at _create (/usr/local/lib/node_modules/n8n/node_modules/@n8n_io/riot-tmpl/dist/tmpl.js:388:14), <anonymous>:3:412)
    at Object._tmpl (/usr/local/lib/node_modules/n8n/node_modules/@n8n_io/riot-tmpl/dist/tmpl.js:335:60)
    at Expression.renderExpression (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Expression.js:214:25)
    at Expression.resolveSimpleParameterValue (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Expression.js:192:34)
    at Expression.getParameterValue (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Expression.js:288:25)
    at getNodeParameter (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1286:42)
    at Object.getNodeParameter (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1508:24)
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/HttpRequest/V3/HttpRequestV3.node.js:978:44)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:652:28)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:596:53

Please share your workflow

Hi @mibrahim547 :wave: Thanks so much for posting the JSON data - would you happen to be able to also share the code of your workflow? You can copy and paste the nodes by selecting all of them in the workflow editor, and then pasting that here between two sets of three backticks (```). That might help us also look into the error for you :slight_smile:

Could you also let us know your n8n version, and if you’re self-hosting or on cloud? If you’re self-hosting, could you provide how you’re running n8n?

its n8n hosted on docker locally.

Update to the issue i tried other fields its working fine.
The issue is only coming up when the field contains Arabic characters or some gif icons.

The current case is triggering when the field is containing the below data:
عناية فائقة للسيارات الراقية أحدث التقنيات الألمانية :de: :telephone_receiver: 0582118700 :arrow_right:بوليش / :arrow_right:جلاد الحماية الشفاف /:arrow_right:نانو سيراميك / :arrow_right:مخفي :arrow_right:غسيل بالبخار

1 Like

Hi @mibrahim547 :wave: You’ve hit the nail on the head - It looks like an issue with non-English characters or emojis.

The HTTP request node does support this, as you can see here:

The string got appropriately sent in the body of my request to

I’m not exactly sure where the expression is erroring in your workflow, but if it’s only when you’re trying to send data through to Retable, you may need to contact Retable and ensure that these kinds of characters are actually supported by their API :bowing_man:

Hi i have texted them but no response so far.
Do you think any other alternative solution to this … ??
can i reformat the text to remove the icons of it ??

Hi @mibrahim547 :wave: I hope their support gets back to you soon - if the issue is with the emojis, then you can certainly try that and the request should succeed. However if they don’t support non-English characters, then your text content may unfortunately be an issue :see_no_evil:

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