Bug: LookUp for a CDS URL field failing - characters not escaped?
My app is saving photos to Azure Blob Storage, setting a secure token then patching that token to a URL field in a CDS table named 'Azure Documents'.
After the save I want to do a LookUp on the URL field to confirm that the record really has saved (yes, I should be able to rely on the return value of the Patch, but that does not appear to be reliable - i.e. the patch will sometimes return true but the record has not been saved). The scenario is that users are often working on the edge Wi-Fi range and when connectivity drops, things can be left in an inconsistent state.
If I try to do a LookUp comparing the URL columns to the value I have just attempted to set for the record, I get the following runtime error:
Looks to me like the : character is making the OData query barf.