Here's an update, I went back to what I used initially %Stream.FileBinary, and setting RemoveOnClose to true fixed my issue with the file being saved in the stream folder where the database files are with a randomly generated name
https://docs.intersystems.com/irisforhealth20251/csp/documatic/%25CSP.D…
https://docs.intersystems.com/irisforhealthlatest/csp/documatic/%25CSP…
Am I missing something? I am saving the data inside response.Data to the fileDestinationPath, which works but it also saves to the database stream folder and never gets purged.
I understand I have to use TmpBinary instead but what is the point of keeping a copy in the stream folder when the code has finished executing? the files are also not named in a way that makes them recognizable other than their extension and file size.
Basically the file is saved to both the location I set at fileDestinationPath and the stream folder where the database file resides.
That's probably it - thank you, but what is the point of permanently storing the stream on disk when the %Stream.FileBinary object is no longer in use since the code has finished executing.
I figured it out, however I am not sure why this is the case:
Firstly the permissions were in order, and I did not change anything since the full permission to the entire table was granted.
When I added a WHERE clause with tbl.SomeBoolean = ?, it would prompt the -99 SQLCODE error, I then attempted to use tbl.SomeBoolean LIKE (?) which worked, I then tried tbl.SomeBoolean = (?) which ALSO worked.
My conclusion: when filtering by boolean (bit) columns using dynamic queries (%SQL.Statement) parentesis must be surrounded by the value, I don't know why this is and it seems strange to only be needed when dealing with bit columns.
Thank you this will help a ton, this is exactly what I was looking for. I'll look into implementing your suggestion instead as yes you're right, our REST codebase does manage security for UnknwonUser - looks like Delegated Authentication is what I am after.
I'll need to read into column-privileges as I had no clue this was a thing, thank you
Hi @Ashok Kumar T
perhaps I didn't make myself clear with my intention;
I want to be able to directly set metadata such as summary, responses, request parameters, etc. directly in the comment above each endpoint method (where I said "can I add metadata here?")
I don't mind if I have to make my own custom implementation to read these values, but I have no idea where to start right now, or whether I even should, perhaps there are already a solution available somewhere?
reason: The swagger spec generated is almost useless, because it does not specify the required parameters / payload for each respective endpoint, it only captures what is inside the UrlMap it seems.
Ideally I'd want to have my implementation of swagger to read the required request parameters / payload, but manually keeping docs updated through comments is a fine starter for my project, is any of this possible already or would I need to create a custom solution using %REST.API ?
EDIT: I just realized you're talking about using specification-first approach, I am talking about the opposite, implementation first, I'll look into going about the specification-first approach.
Thank you again for your help.
The issue was that a secure flag must be set in the parameters of SetCookie method. I couldn't find any documentation on this when upgrading from Caché 2017 to Ensemble 2018.
Thank you for your reply, I have already tried every option, None, Lax and even Strict again.
The error doesn't happen in the browser, in fact I don't see the error until I dig into the application error log or global.
I'll keep tinkering around, I assume there must be a setting somewhere not set, everything else is functional - I'll update this thread if I find something.
I was hoping I didn't have to do that, that's fine it wasn't as complicated eitherway. Thank you