go to post David Hockenbroch · Jan 2 I'll echo the idea that you don't really want to be using the /api/atelier web app this way because of the %Development requirement and the arbitrary SQL execution, and because it includes a lot of other functionality that you probably don't want people to have access to. BUT if you're really intent on using that API, then you could make your own web application in the management portal that uses the same dispatch class that /api/atelier does and create a new resource to be the required resource to access it. Make sure your users have permission to use that resource, and then assign the appropriate table and view permissions in a role that you either give to those users or assign to the Web Application as an application role.
go to post David Hockenbroch · Dec 26, 2025 Are you looking for something like: ClassMethod ExceptionTest() [ Language = python ] { import sys import iris import traceback try: print(1/0) except ZeroDivisionError as e: errobj=iris.cls("%Exception.General")._New(str(e),42) stack_trace_list = traceback.format_tb(e.__traceback__) if stack_trace_list: last_instruction_line = stack_trace_list[-1].strip() errobj.Location = last_instruction_line a = errobj.Log() } Which gives:
go to post David Hockenbroch · Dec 4, 2025 Page not found, or Invalid Action? If it's page not found, how is the web application configured?
go to post David Hockenbroch · Nov 26, 2025 @Enrico Parisi , with Global Masters, we get a few points for having an answer marked as correct on the community. People often only mark the first correct answer they see. So if the user who posted the question didn't see this thread before the AI bot's post appeared, it's somewhat likely that the bot's post will be marked as the correct answer even though a human user answered the question first. That's all. Seems just a little unfair to me.
go to post David Hockenbroch · Nov 25, 2025 @DC AI Bot When I checked on this post earlier today, Vitaliy's correct answer was here, but the AI Bot's was not. Now it's showing here as if the AI Bot's answer was first. That is troublesome, particularly if Vitaliy is a Global Masters user.
go to post David Hockenbroch · Nov 25, 2025 The specific issue here is probably that when you tried to set text = type.%Get("text"), the variable "type" wasn't an object because it didn't exist or wasn't a dynamic object/array within the original object. You might want to try: set iter = identifiers.%GetIterator() while iter.%GetNext(.key, .value, .type ) { set type = value.%Get("type") if $ISOBJECT(type){ set text = type.%Get("text") } else{ set text = "" //Or whatever you wanted to do if type wasn't an object. }
go to post David Hockenbroch · Nov 25, 2025 Maikel, if your variable is named var in your ObjectScript code, then you would use where xyz = :var in the embedded query. The colon marks that this is a host variable.
go to post David Hockenbroch · Nov 25, 2025 You can set this up using your routine mappings. You can have each namespace have a different database for its globals but share a database for the routines. Then they'll all have their own data, but be running off of the same code.
go to post David Hockenbroch · Nov 18, 2025 I only have back to Cache 2018, not 2017, but can you try: set myproc = ##class(%SYS.ProcessQuery).%OpenId($J) if myproc.ClientExecutableName = "CSTUDIO.EXE"{ //You are in Cache Studio } else{ //You are not in Cache Studio }
go to post David Hockenbroch · Nov 10, 2025 I'm not totally clear on what you're trying to do, but I have a feeling you might want to replace "quit" with "return status". Inside a catch block, a quit command will quit just the catch block and code execution will continue after it. Replacing that with return status would make the code execution stop right there, returning the error.
go to post David Hockenbroch · Oct 30, 2025 Here's my small but useful contribution: Add an "Add Server to VS Code" Option to System Tray Icon
go to post David Hockenbroch · Oct 30, 2025 Look in the System Management Portal under System Administration, Security, Applications, Web Applications, and look for the /csp/sys application. That's the System Management Portal. You can probably set a required resource there, and then only people who have that resource should be able to access it. You'll probably want to make a new resource, not just use an existing one. Just make sure you have that resource before you make that change so you don't lock yourself out!
go to post David Hockenbroch · Oct 27, 2025 Calling the methods this way is effective for testing the methods, yes. You just want to get really familiar with the %CSP.Request class. This approach isn't a good way to troubleshoot issues with your routes, or with authentication, though, as it bypasses those steps. For that, you'd probably have to define %request appropriately, then call some of the methods your API inherits from %CSP.REST, but I'm not as familiar with those.
go to post David Hockenbroch · Oct 22, 2025 And in addition to all of that, one of the workarounds people seem to like using is to have things comma-separated and enclosed in " to make sure it's getting the right commas, but I'm working on ERP software for the millwork industry in America. We're still allergic to metric here, and we use " to mean inches and ' to mean feet, so we can't use those either!
go to post David Hockenbroch · Oct 22, 2025 I know it's odd, but I've had three separate companies ask me for data formatted this way in the past couple of years. I'm not sure why, other than that the pipe is less common to run into within the data than commas.
go to post David Hockenbroch · Oct 21, 2025 We have had a few people ask for a CSV using a pipe as a separator. If you run into that and need to open it in Excel, you do that by going to the data tab, then click From Text/CSV. It may detect the separator character automatically, but if not there is a place where you can set it. (You may want to right click on the GIF and open in new tab if it's too fuzzy.)
go to post David Hockenbroch · Oct 21, 2025 @Stephen Canzano , when you are testing you can also manually define %request and give it a body and whatever else it needs before you call your class method. For instance: set %request = ##class(%CSP.Request).%New() set %request.ContentType = "application/json" set %request.Method = "POST" set %request.Content = ##class(%CSP.CharacterStream).%New() set json = {}.%New() set json.firstname = "David" set json.lastname = "Hockenbroch" do %request.Content.Write(json.%ToJSON()) Then you can call your class methods and the %request object you usually manipulate in those methods will be defined.
go to post David Hockenbroch · Oct 21, 2025 @Evgeny Shvarov it's like this: try{ //Do things here } catch ex{ do ex.Log() return ex.AsStatus() } If you do this, then the error gets logged in the application error logs in the system management portal, and a JSON representation of the exception gets returned through the API.
go to post David Hockenbroch · Oct 15, 2025 I'm not 100% certain, but I think you could use: set osuser = ##class(%SYS.ProcessQuery).%OpenId($J).OSUserName set userprofile = "C:\Users\"_osuser
go to post David Hockenbroch · Oct 6, 2025 You can create and log exceptions so that they show up in the application error logs in the SMP. That's how I prefer to do things.