Here you can see I have 2 records, one has the value "abc\ndef" and the other has "abc\rdef". I can query the first one with {Value}="abc\ndef", but I cannot figure out how to query the second one. The obvious thing of "{Value}="abc\rdef" does not wo...
Also, looking at your code, I realized that I missed the case of "\r". I added an example with that in it:
$ curl "https://api.airtable.com/v0/$AIRTABLE_BASE/testing%20escape%20functions" \
-H "Authorization: Bearer $AIRTABLE_API_KEY" \
...
sigh My post got marked as potential spam and is awaiting moderation. So if you come here to read it, and don’t see it, then that’s why and you’ll have to wait until a moderator approves it. This forum software really hates me :disappointed:
I have to disagree with you though about my code being incorrect. :stuck_out_tongue_winking_eye: My example was tested in Python3 using the airtable-python-wrapper against a live API. The escaping of newline characters and tabs is necessary, other...
To interpolate data into a query, that data needs to be escaped according to the rules of the query language. If you don’t do this, then the data can affect the structure of the query.
For example, a malicious user can enter their email like so, caus...
@Dominik_Bosnjak’s Javascript solution… (link) I can’t tell if it’s correct or not. It looks like interpolation, which would make it a security vulnerability, but it’s doing it in a template literal tagged with write, so JavaScript will pass it to th...
