Question Kurro Lopez · Nov 4, 2021 How to convert datetime ISO 8601 to ObjectScript datetime Hi all, I have a process that recive a datetime in ISO 8601 format (YYYY-MM-DDThh:mm:ss+001) to %timestamp value. Example: set myDatetime = "2021-11-04T11:10:00+0100" I've triyed use $SYSTEM.SQL.CONVERT(myDatetime,"SQL_TIMESTAMP") but it doesn't work. Any idea? Regards,Kurro Lopez #Caché 1 7 0 663
Question Kurro Lopez · Oct 29, 2021 Use Rule to call WS 1 to n Hi all. I'm trying to create a route rule that can call to a web service according to a parameter of a message. My first attempt is the following: I have a common class with all information, BuscarHuecoRequest, and check what is the value of property "CodigoProveedor". #Business Rules #Caché #Ensemble 1 1 0 202
Question Kurro Lopez · Sep 23, 2021 Unexpected ContenType when call a WS Soap Hi community, I have a SOAP Client class that connect to a WS Service. This structure and configuration is the same for some providers that are integrated with my solution. If I call to a provider, it returns the XML expected. But there is a provider that raises an error: ERROR #6243: HTTP request to SOAP WebService returned response with unexpected CONTENT-TYPE: application/wsdl+xml #SOAP #Caché #Ensemble 1 3 0 265
Article Kurro Lopez · Aug 9, 2021 4m read Add a default setting value by code Hi community, This is another article about how to perform actions that you can do in the web portal but via code. Today.... Add a default setting value by code #Beginner #Management Portal #Tips & Tricks #Caché #Ensemble #InterSystems IRIS Open Exchange app 8 0 3 442
Article Kurro Lopez · Aug 4, 2021 4m read Add a business item in your production by code Hi community, This is another article about how to perform actions that you can do in the web portal but via code. Today.... Add a business item in your production by code #Beginner #Business Operation #Business Service #ObjectScript #Tips & Tricks #Ensemble #InterSystems IRIS 8 0 2 359
Article Kurro Lopez · Jul 30, 2021 3m read Add a Web application by code Hi community, I'm going to publish several articles on how to perform actions that you can do in the web portal but via code. Today.... Web Applications via code #API #Beginner #Code Snippet #ObjectScript #Tips & Tricks #Caché #Ensemble #InterSystems IRIS 9 0 3 510
Question Kurro Lopez · Apr 28, 2021 Query method in a class %Persistent using itself as parameters Hi all, I'm wondering if is possible to get the values of itself to run a query. I want to create some query to find a value into a %Persistent class but each one use diferent values. #SQL #Caché #HealthShare 1 6 0 240
Question Kurro Lopez · Apr 23, 2021 Sort alphabetically a list of names Hello everyone, I don't want to believe that Intersystems didn't add a method/process/rule to sort alphabetically a list of names (in array, $ LB or whatever) I haven't found any documentation about this. I've even tried comparing two strings but have not found a solution. My cry for help is... Does exists any command to compare two strings and check if one of them is lower or upper according to aphabet? Please, give me a light in this dark Best regards.Kurro Lopez #Caché 1 7 0 822
Question Kurro Lopez · Mar 10, 2021 SOAP Error CONTENT-TYPE response text/html instead of text/xml Hi all, I have a very weird error when I'm calling to a SOAP Webservice as client. I've create all objects to invoke to this SOAP using the add-in "Assistant SOAP" in Eclipse, it has created all objects (Response, Request, Business operation WS class, etc...). When I call to this service it retuns the following error message: ERROR #6243: HTTP request to SOAP WebService returned unexpected CONTENT-TYPE response: text/html. #Business Operation #Interoperability #SOAP #Caché 2 4 0 3.7K
Question Kurro Lopez · Feb 25, 2021 Export partial JSon to a response message Hi all, I have a API operation that is calling to a external process. The answer is a big json but I only want a pice of the full content. My first attempt is: #Caché 1 2 0 228
Question Kurro Lopez · Aug 25, 2020 Search an object in a ListOfObj Hi all. I have a reponse message that has a property of the type %Collection.ListOfObj and I need to search for an item in this list. Let me show you. #ObjectScript #Caché 1 5 0 342
Question Kurro Lopez · Apr 17, 2020 Failed to acquire exclusive lock error Hi all, I have a class that has been working so far :( The class extends the EnsLib.RecordMap.Service.FTPService class and add some information for each rows. Now, when it saves the object it is raising the following error ERROR #5803: Failed to acquire exclusive lock error I've seen the other question in the community and I've tried to unlock #Interoperability #Caché #Ensemble 1 5 0 1.2K
Question Kurro Lopez · Oct 30, 2019 API RESTful Version Hello, We need to create a versioning of an existing API, so we going to set a default version (so far) for current connections to version 1 My first attempt is: #Business Service #REST API #Ensemble 3 5 0 391
Question Kurro Lopez · Sep 4, 2019 BS FTP error waiting for files Hello everyone,We have a process that is listening to an FTP service to collect some CSV files and process them. The process works correctly and when it ends it clears the directory waiting for it to enter some other file.We have been receiving the following error message for a long time: #Business Service #FTP #Ensemble 1 4 0 834
Question Kurro Lopez · Jun 24, 2019 Create a Pass-through SOAP WebService Hi all,I'm triying to create a SOAP Pass-through acording to Configuring Pass-through Business Services instructions, but I'm not able to run it I'm using the following WebServicehttp://www.dneonline.com/calculator.asmx?wsdl #Interoperability #SOAP #Ensemble 2 3 2 922
Question Kurro Lopez · May 24, 2019 How to copy array values from JSon to object using DTL? Hi community,I need to create a DTL to get values from a JSon (%DynamicObject) to a class.Thre first items is copied fine, however when it tries to get the values from an array it raises an error. #DTL #Ensemble 1 5 1 805
Question Kurro Lopez · May 22, 2019 How to delete an item from a production by code? Hi all,I am trying to delete an item from a production through a routine that installs and disables items.To add any item, I have no problems, even to enable and disable some particular items.The problem arises when I try to eliminate the production item, because when it does, the production become unstable and only works again when this item is added again in the collection (or the item is deleted manually in the production.cls)This is my code attempt: #Ensemble #InterSystems IRIS 1 11 0 666
Question Kurro Lopez · May 20, 2019 How to sync Server and local cache code using Visual Studio Code Hi all,I wonder how to sync my server code to my local code using Visual Studio Code.Previously, using Atelier, you could open a view of server and can copy the code to the current project, also if I change a BP, I could sync the code because I had a signal that It's warning me that there was a change and it needs to be updated.I thing i shouls opening the ObjectScript: Explorer and select the code directaly, and right click -> Import and compile current file (Ctrl + F7)If I use this command, the ouptut window shows: #VSCode #Caché 1 16 0 1.6K
Question Kurro Lopez · May 16, 2019 How to ignore serialize a property in a class to JSon Hi all,I have a class that I want to serialize to JSon. So I'm using the object %ZEN.Auxiliary.jsonProvider) #JSON #ObjectScript #Caché 1 8 0 581
Question Kurro Lopez · May 10, 2019 Get parent classname Hi community. I need to get the parent classname of a class, but I don't find how to do it. I have a class Parent (MyLibrary.ParentClass) and two classes inherited from the parent class #Business Process (BPL) #Ensemble 1 3 0 505