Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
SaaS
What are the exact steps to reproduce this issue?
Hi All,
I have an issue and I wondered if there was a workaround. I currently use baserow with.2 other systems. I use Microsoft Flow to check every 30 minutes for any changes in one of the systems and when it detects a change it passes this data to Baserow as a new/modified row.
The issue I have is that part of the request payload sent to Baserow is a field called “Sitecode” which contains an ancronym generated by the system e.g. AA, AB, CD. I currently use a lookup in a new column called Site Location which converts ‘AA’ to ‘Acne Inc’.
The issue is that when a site code appears that isn’t in my list, the row fails to be posted and i get this error:
‘{ “error”: “ERROR_REQUEST_BODY_VALIDATION”, “detail”: “The provided text value ‘CK’ doesn’t match any row in the linked table.” }’
Is there a way I can make the column accept any value and still look up? e.g. leave the Site Location field empty? Or a better suggestion on how to pass the site location dynamically?
Hi @NicoR93, I am not sure what you are trying to do. What is “your list”? What does it mean something is not on your list? How is your lookup setup?
In general, it is best to report problems as a list of steps to reproduce. So please describe all your tables, relevant fields (their type etc.), and specific steps taken. You can also create a minimal reproducible example and post it here as workspace export.
Unfortunately, I couldn’t type it all out as there was a character limit on the post. I have two columns in my table - Site Code and Site Location.
My external system generates a Site Code (2/3 characters) and I want to be able to present this information with the full Site Name e.g. Acme Inc. Currrently using 2 Tables - one with the data and one with Site Code and Site Name. I then use Lookup to dynamically get the Site Name via Site Code.
The issue is when the Site Code doesn’t exist in that Table then the lookup fails which means the Webhooks request fails with the above error. I’m looking for a way of making the Site Location lookup optional so if the Site Code is not present then the row is still added but the Site Location column is left blank.
We have asked our external provider for all site codes but struggling to get them all at the moment.
I see. Basically what you need is for the “create rows” (or “update rows”) endpoint to create a missing entry automatically, instead of returning error, correct?
I don’t think this is possible now, so the solution is to do a bit more on your automation side, where you create an entry for the missing code first.