Is it possible to pretty format a json string: Map m = Map (data); printLine(m.toJson()); Outputs: { "First": "Martin", "Last": "Andersen"} I would like to have it like this: {   "First": "Martin",   "Last": "Andersen" }   Regards Martin

Hi, I am trying to create a webhook via a CRMScript based on changes made to project members. It looks like it should be possible, https://docs.superoffice.com/en/automation/webhook/reference/project-member-events.html , but nothing fires when I add/edit or delete a project member. Here is the code registering the webhook. #setLanguageLevel 4; String targetCrmScript = "ProjectMemberWebHook"; String[] events = String("projectmember.created,projectmember.changed,projectmember.deleted").split(","); NSWebhookAgent webhookAgent; NSWebhook webhook = webhookAgent.CreateDefaultWebhook(); //NSWebhook webhook = webhookAgent.GetWebhook(1); webhook.SetEvents(events); webhook.SetName("Project Members Web Hook Handler"); webhook.SetType("crmscript"); webhook.SetTargetUrl(targetCrmScript); webhook.SetErrorsEmail("trevor.sharp@synergytechnology.co.uk"); webhook.SetState(1); // Set it as active! webhook = webhookAgent.SaveWebhook(webhook); printLine("Webhook succeeded with ID: " + webhook.GetWebhookId().toString()); And here is the webhook. #setLanguageLevel 4; String variablesAvailable = ""; Map m = getVariables(); while (!m.eof()) { variablesAvailable = variablesAvailable + m.getKey().stripLeadingAndTrailing(" ") + " - " + m.getVal().stripLeadingAndTrailing(" ") + "<BR>"; //Move To Next Record m.next(); } log(variablesAvailable); It writes ok to the log when I enable the webhook, but nothing is added to the log when I make changes to the Project Member, and I cannot get any traces from this script. Also with the new screen for creating the webhooks via the GUI, this does not reference the Project Members table, which makes me wonder if it is not supported, but then why have a whole help page on project member events if it is not supported. Does anyone know whether the project members web hooks should fire or not, have I missed something in my code, or am I trying to achieve the impossible. Many thanks, Trevor

Hi, You may have seen from a previous post (where I raised a question on document filename formats), that I have written a script that uses the "NSQuoteAgent.GetOrderConfirmation" function, to allow one of our customers to produce multple order documents against the same quote, but using different document templates for each document. Our customer needs multiple templates against the quote, for things such as Works Order Sheet, Picking Form etc., and the "GetOrderConfirmation" function works really well, as it allows you to save in SuperOffice multiple "Order Confirmation" documents, using different "Order Confirmation" templates against the same quote.  Below is a screenshot of the script, that runs from the Sale Task menu. The trouble is, that it does not seem to respect the user's Number and Date format when producing the document. Below is a screenshot of part of an order confirmation document produced when raising the document in the normal manner (at the point of placing the order, which can only be done against one of the document templates for any given quote).  The date correctly shows in the UK date format, as per the customer's number and date format. When I produce the same document via a CRM Script, using the following code. NSQuoteAgent quoteAgent; String quoteDoc = quoteAgent.GetOrderConfirmation(quoteVersionId, confirmationTemplateId); This is the document it produces, with the user's number and date format being ignored. As the script runs from the Sale Task menu, I expected the script to run in the context of the user, and therefore use the user's number and date format settings, but this seems not to be the case. Am I missing something in my code, or is this a bug with the function in SuperOffice? Many thanks, Trevor

I try to get tickets, using this NSArchiveAgent agent; NSArchiveListItem[] result = agent.GetArchiveListByColumns2 ("FindTicket", "ticketId,title,status,person/personId", "", "ticketId>'0'", "ticket", 0, 200); printLine ("Row count: " + result.length().toString()); foreach (NSArchiveListItem i in result) { Map col = i.GetColumnData(); col.first(); while (!col.eof()) { print(col.getKey() + ": " + col.getVal() +" - "); col.next(); } }   But it only seem to return open tickets. Why is that - what am I missing?  

Simply put, I want to send an email when certain criteria are meet, but I can't find any documentation about the subject. I found a forum post with the class name NSEmailAgent, but it does not exist? Maybe it used to exist? It should of cause be from within SuperOffice, and be shown in the archives, and not some mail-chimp Rest call. Regards Martin

Hi, we have an Online customer who has been using CRMScript to get data from a webservice which is protected by NTLM auth. Somewhere around the time they were upgraded to version 12 all calls from CRMScript using NTLM started to fail. It seems to use basic auth even though authenticationMethod is set to ntlm. Example code: HTTP http; http.setOption("authenticationMethod", "ntlm"); http.setOption("username", "foo"); http.setOption("password", "bar"); http.get("https://testing.requestcatcher.com"); On an older onprem solution I see that setting http.setOption("authenticationMethod", "ntlm") causes the Authorization header to be "Authorization: NTLM ****", but in Online v12 the Authorization header is set to "Authorization: Basic *****". Has NTLM support been removed from version 12? It is still mentioned in the documentation: https://docs.superoffice.com/en/automation/crmscript/reference/CRMScript.Native.HTTP.html

I saw this https://community.superoffice.com/en/technical/blogs/archive/building-custom-rest-api-methods-using-crmscript/?epslanguage=en And it works out of the box you could say. But I need a big chunk of data in the body of the request, can I do that?