Application Programming Interface forums
Area for questions and answers about SuperOffice API's.
Ämnen
All conversations (4947)
update a bool using setValue
Hello, I'm new to this code language and I still haven't figured a lot out yet. I've got this section of a script: if (c.setValue("contact_id", contactId.toString())) { if (mismatchFound) { c.setValue(BOOL_UDF_KEY, "1"); printLine("Updated:" + companyName); } else { c.setValue(BOOL_UDF_KEY, "0"); } c.save(); } else { printLine("Failed to load contact: " + contactId.toString()); } Where I'm trying to update a UDF Checkbox, but I don't know exactly how to update it or how to pass the value. Passing it as a string return the error: EjScript::RunTimeException: Value::getBool(): m_type != TypeBool but passing it as anything else is not allowed when using setValue. Any input or advice on this would be greatly appreciated.
FN
Fabian Nilsson
Ämne:
Service and CRMScript Discussion
Senaste svar
Thank you, this worked great!
FN
by Fabian Nilsson
Decompress GZIP in CRMscript
Hi, we're trying to work with data returned form an API endpoint from our ERP system. The data is returned by the HTTP post as JSON that is compressed with GZIP. Is there any way to deflate this data within CRM script? Thanks in advance.
MS
Manuel Severin
Ämne:
Service and CRMScript Discussion
Senaste svar
Hi Manuel, I don't think CRMscript is capable of applying such a step. I would recommend decompressing 'outside SuperOffice'
by Bas Kreijveld
Webhook on contact.changed or created will not trigger
Hey, I set up a new simple webhook, to just throw something at https://webhook-test.com/ and see what sticks It fired the original "I've been created" message: But nothing but silence ever since. The webhook is active, and from what I can see, correct. But no matter if I change the name, department, category on a contact/company or create a brand new one - nothing but silence from the webhook. Name: Webhook test for when contact is changed or created from service ID: 73 State: 1 Secret: TargetUrl: https://webhook-test.com/d**************************************8 Registered By: BK Registered Date: 2025-07-22 15:58:58 Updated By: Updated Date: Type: webhook Events: - contact.changed - contact.created The webhook was created using CRMScript Rest API: String targetUrl = "https://webhook-test.com/d**************************************8"; NSWebhookAgent webhookAgent; NSWebhook webhook = webhookAgent.CreateDefaultWebhook(); String[] events = String("contact.changed, contact.created").split(","); webhook.SetEvents(events); webhook.SetName("Webhook test for when contact is changed or created from service"); webhook.SetType("webhook"); webhook.SetTargetUrl(targetUrl); webhook = webhookAgent.SaveWebhook(webhook); printLine("Webhook succeeded with ID: " + webhook.GetWebhookId().toString()); I don't see any reason for this not to work. The type could be invalid. In the documentation the examples used crmscript and linking it up to a inlcudename in targetUrl. But since the initial test message went through. I think the webhook-test.com url in targetUrl and type "webhook" is working. Any ideas?
BK
Bjørn Karlsen
Ämne:
Service and CRMScript Discussion
Senaste svar
Hi Bjorn, Propably due to the application pool being recyled during the night, this causes the caches to be flushed. Next time, try running below code to make sure the caches where flushed after registering the webhook: NSDiagnosticsAgent diagnosticsAgent; diagnosticsAgent.FlushCaches();
by David Hollegien
Archive Emails trigger
Hello! I am writing a script that creates a follow-up a few days after specific emails are archived. But I realised that archiving an email is not detected by triggers or by webhooks. I tried reading through a few forum entries, and found that some people use the "MailLink Document Archived command" preference as a trigger, but I don't understand how to use it. In the pop-up that comes up when I try to add a preference, I am able to link to a command. Should I just add the doScript-link from my CRMScript there to use it as a trigger, or how does it work? Or should I use something else as a trigger for when my email is archived, that allows me to run a CRM-script?
Beata Martinsson
Ämne:
Service and CRMScript Discussion
Senaste svar
Hi, Just had a use case today for using a webhook based on an email being created. Can confirm that the document.created webhook is triggered when you archive something from mail link.
by David Hollegien
Change outbox on autoreply
Hello! I want to change my outbox for an autoreply to a new forms answer (it creates a ticket). But, nothing is working! Right now, the auto-reply comes from an email that looks like "name_15@companyname.suocrm.eu", even though we have specified in the Address for the mailboxes that it sould come from "Name@companyname.com" in the "Mailboxes" tab in the request settings. My thought was to either change the filter address for the ticket, change the "outbox.from" value in a outbox trigger, or send an email manually, but when using some sort of the variation of setValue("from","name@companyname.com") or setOutputValue("outbox.from","name@companyname.com"), the email is not revieved. In the outbox, it states that the email is sent, but it is not recieved on the other side. Anyone have an idea on how to fix this?
Beata Martinsson
Ämne:
Service and CRMScript Discussion
Finding User Defined Fields values on a company card through SearchEngine
In CRMScript I'm trying to find all companies where my UserDefinedField (date) is in a certain timeframe. From what it seems, dates are stored in the UDXXXsmall table as Longs [1], so im thinking i somehow have to do something with the userdef_id (FK udcontactSmall) table of my contact table [2]. However, when trying a few of the "Long" values, i get just long numbers, and not the date values im after. I've set the UserDefinedField as Indexed, and tried all long01-04, but there are just numbers which i dont understand what to do with. I can't make sense of how to get the actual values, and would appreciate some help, please let me know if more information is needed 😊 [1] https://docs.superoffice.com/en/custom-objects/reference/index.html [2] https://docs.superoffice.com/en/database/tables/contact.html
FL
Frederic Lien
Ämne:
Service and CRMScript Discussion
Senaste svar
I thought it looked like Unix Epoch, but when i tried converting it i got dates in 2023 and 2028, where i was looking for something this year :p Chose to go with the method that Tony put down here, because i can directly just put in the ProgId, but thank you for sharing your insights 😊
FL
by Frederic Lien
Sentry denies Write access
I have a CRM-Script that edits custom-fields on a sale. But for one user, and only one user, this error message comes up. I don't understand what this means, CRM-Script doesn't check which access-rights a user has before it makes changes to the db, right?
Beata Martinsson
Ämne:
Service and CRMScript Discussion
Senaste svar
I just looked into this, and the user had access to "Delete" on "other users --> sale" (And all other sale-things) in the matrix, strange! I belive that they are allowed to do the necessary changes since my scipt only changes the sale in the current context where the trigger is triggered. I applied the try-catch block, I hope that that one allows me to get a clearer error messade.
by Beata Martinsson
Convert Attachment to CRM Document
Is there any way to simply get an attachment from the attachment db table and convert it to a CRM document that can be added to a sale, contact etc etc? Like, in a imaginary scenario I wish for a like createCRMDocumentEntityFromAttachmentId(1) method or function? Or just any other way to solve it without having to parse the document from the attachment body to a CRM Document. I am trying to add all attachments from a request to the customer card.
Beata Martinsson
Ämne:
Service and CRMScript Discussion
Senaste svar
Oh, okay good to know! Thank you :)
by Beata Martinsson
Get listitem by listId
Hello. When it comes to defining udef in Sales with respect to lists there are 2 ways. 1. Creating a user defined field and assign a standard list to it. 2. Creating a user defined field and assign a user defined list to it. I have problems with getting the item value from a standard list. In the table UDefField the only reference to a standard list table is the field listTableId as far as I can see. If I have defined a userdefined field that points to one of the standard entities (ie, associate, sale stage, project status) and get a the item value id, how can I then fetch the item value if the only lookup field I have is the listTableId ? https://docs.superoffice.com/en/database/tables/udeffield.html I can see there are functions agent.GetListIdByListName("name") and NSMDOListItem item = agent.GetListItem("listname", itemId) but I cannot see a way to get listitem when I only have the listTableId
Ummair Tahir
Ämne:
Service and CRMScript Discussion
Senaste svar
Hi Ummair, OK, Here are three ways to get list name from ListTableId: 1: Hardcode a Map based on known table Ids (documented in the Database Reference ) Map listTableMap; listTableMap.insert("219","AcademicTitle"); listTableMap.insert("225","AmountClass"); listTableMap.insert("2","Associate"); listTableMap.insert("61","Business"); listTableMap.insert("64","Category"); listTableMap.insert("70","CompanyInterest"); listTableMap.insert("109","Competitor"); listTableMap.insert("73","ContactInterest"); listTableMap.insert("19","Country"); listTableMap.insert("97","Credited"); listTableMap.insert("112","Currency"); listTableMap.insert("91","Function"); // Proj. Member Type listTableMap.insert("216","Intent"); listTableMap.insert("94","MrMrs"); listTableMap.insert("76","Position"); listTableMap.insert("79","Priority"); listTableMap.insert("82","Rating"); listTableMap.insert("103","Reason"); listTableMap.insert("222","Rejection"); listTableMap.insert("48","Relation"); listTableMap.insert("100","Source"); listTableMap.insert("88","Status"); listTableMap.insert("130","Template"); listTableMap.insert("67","TypeFollowUp"); listTableMap.insert("85","TypeProject"); listTableMap.insert("106","TypeSelection"); listTableMap.insert("136","UserDefined"); listTableMap.insert("59","UserGroup"); String tableName = listTableMap.get("2"); printLine("Table Name: " + tableName); // prints: Associate 2: Dynamically lookup the table name from the sequence table String GetTableName(Integer tableNumber) { String [] searchFields = String("sequence.TableName").split(","); NSArchiveRestrictionInfo[] restrictions; NSArchiveRestrictionInfo res1; res1.SetName("sequence.TableNumber"); res1.SetOperator("="); res1.SetValues(String(tableNumber.toString()).split(",")); restrictions.pushBack(res1); NSArchiveOrderByInfo[] order; String[] entities = String("").split(","); Integer pageSize = 250; NSArchiveAgent archiveAgent; NSArchiveListItem[] rows = archiveAgent.GetArchiveListByColumns("Dynamic", searchFields, order, restrictions, entities, 0, pageSize); foreach (NSArchiveListItem row in rows) { Map rowData = row.GetColumnData(); String tableName = rowData.get(searchFields[0]); return tableName; } } String table = GetTableName(2); printLine("Table Name: " + table); // prints: ASSOCIATE 3: Use the UserDefinedFieldAgent to look up the list name: NSUserDefinedFieldInfoAgent udefAgent; NSUserDefinedFieldInfo udefInfoList = udefAgent.GetUserDefinedFieldFromProgId("SuperOffice:7", 1); // 1: Contact, 2: Person, 3: Project, 4: Sale, 5: Temp, 6: Appointment, 7: Document printLine("List Name: " + udefInfoList.GetMdoListName()); // prints: List Name: business Hope this helps!
by Tony Yates
how to get value of user-defined list item per crm script
Hi, in SO Windows with vbscripts by Trigger Sales beforeSave, I can get value of user-defined list item: division = objSO.GetListItem(currentSale.Udef.ByProgId("SuperOffice:1").ListTableId, division).Text but in SO CLoud or SO Web with crm script, with this i get ID of List item back: devision = ed.getInputValue("SaleEntity.UserDefinedFields.SuperOffice:1"); Is there way to get its ListItem Value back, only with SearchEngine? Thanks!
Jianchun You
Ämne:
Online development and web service API's
Senaste svar
Answer to Ummairs question: https://community.superoffice.com/en/technical/forums/api-forums/service-crmscript/get-listitem-by-listid/
by Tony Yates