Hi there,
I’m investigating using NileDB with my Plasmic App. Part of this process I’m providing a tenant_id as a query filter. My thought was to put this into an input field so that I can provide it as a dynamic field to the query.
Problem is when I define it as a dynamic value it returns ‘invalid input syntax’.
Yet if provide it as a string to the query filter, results are returned.
Any ideas how to tackle this one? Project ID is iFh9VYptsBmTTUR5KXcQDx
I woul try debugging this by making a text element with a dynamic value to print out tenant2.value.
Just gave this one a try.
The string looks fine from what I can tell.
Is the dynamic value being set as $state.tenant2.value correct?
Yes that does look correct. Can you confirm in the network tab what is being sent in the request?
And does that request result in the invalid input syntax for type uuid: "" error? If so, it seems like that may be a problem on your integration’s API.
I just tested this and you are right.
It looks like as per network request the string is being set with “”
“d24419bf-6122-4879-afa5-1d9c1b051d72”
This is a screenshot of the db workbench with “” it has the same error as I get in plasmic
When not using “” the result is returned as expected
I tried stripping “” from the output with the same result
Any ideas if I could modify the output? if not I’ll have to investigate other options.
The quotes you see "" are expected to be shown in the devtools, but it wouldn’t actually be sent to your API. So I believe it’s something in your API that is inserting those quotes.
Thanks Jason, In that case what would be the difference between using a dynamic value vs just entering the string in the DB query?
You’re right, the hardcoded value and the dynamic value should be the same, but they’re not. We’ll investigate deeper into this issue…
Thanks for looking it!
