Retable - Update Row API

Questions
1

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’).item.json.body.data.user.biography_with_entities.raw_text }}”
}
]
}
]
}

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.

Details

Time

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

Item Index: 0 | In or underneath Parameter: JSON

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

"={ “rows”: [ { “row_id”: 1, “columns”: [ { “column_id”: “wTmZwW6tb7wsVX54”, “update_cell_value”: “{{ $(‘Enrich Profile’).item.json.body.data.user.biography_with_entities.raw_text }}” } ] } ] } "

Stack

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

image
image919×349 26.2 KB

3

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?

4

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
5

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:

image
image2962×1266 212 KB

The string got appropriately sent in the body of my request to webhook.site:

image
image2656×1200 263 KB

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:

6

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 ??

7

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: