Application Programming Interface forums

0 Abonnenter

3 Emner

4908 Samtaler

Area for questions and answers about SuperOffice API's.

push_pin lock

Online Quote Conector - List Configuration Field

Hi, I am trying to add a List Configuration Field to my online quote connector.   The documentation suggest that I implement GetQuoteList to provide the List infromation: So I implemented it as follows: However, this event never fires, and my Listbox displays empty: Please can you advise where I have gone wrong? Cheers Rich      
Richard Hacker
3
5
10. jan. 2025 | 12.36 PM
Emne:
Online development and web service API's

Seneste svar

Forgot to mention that I have also tried to change the ListName property in the ConfigField to be all lowercase, and have also tired a shorter name; but still no luck :(  
by Richard Hacker
16. jan. 2025 | 09.23 AM
push_pin lock

Using UDList for setListName on an EventDataDialogField

Hi, I love using the dialog's in CRMScript, they really do help us to provide very powerful automations.  I notice that we can use the setListName to link a List type dialog field to an existing list in SuperOffice (I.E. associate, SaleType etc.), without having to add list items manually.  But can this be linked to a list from the UDList table.  It seems not to be possible, as there is not parameter for the UDListDefinition_id.  If this is not possible, can it be linked to a Custom Object table? Many thanks, Trevor
Trevor Sharp
2
2
15. jan. 2025 | 02.51 PM
Emne:
Service and CRMScript Discussion

Seneste svar

Hi David, That is perfect, thank you for providing this answer so quickly, this will be very helpful. Thanks again, Trevor
by Trevor Sharp
15. jan. 2025 | 03.04 PM
push_pin lock

Updating the mirror directly

We use mirror DB in combination with other, local DBs for historical data.  Occasionally we cannot wait for the mirroring delay, after we updated the cloud properly. More specificaly, we turn on/off the "Done" attribute on projects through API.  Is it safe to also update the mirror to the same value or will the mirroring process complain ? 

IT

Inge Simon Thorbjørnsen
2
3
15. jan. 2025 | 12.20 PM
Emne:
Client libraries and tools

Seneste svar

Thanks, guys.   I appreciate the warning, and I fully agree.  However this is a very special case, and the updates will/can only happen via a protected method in one single class.

IT

by Inge Simon Thorbjørnsen
15. jan. 2025 | 01.53 PM
push_pin lock

Create documents via script with Sharepoint as document library

Is it possible to create Sharepoint documents through crmscript so that they are accessible via SuperOffice? (If you have a Sharepoint connection.)

FL

Fredrik Larsson
2
1
10. jan. 2025 | 09.47 AM
Emne:
Service and CRMScript Discussion

Seneste svar

Yes, you can use the normal document API's, SuperOffice will take care in the backend of writing in to the correct document library (either SO ARC or SharePoint). Only important part is that the Sharepoint library has been set up with a system user, so that you can write documents to SuperOffice (and SharePoint) without having to have a user interactive session. See documentation.
by David Hollegien
10. jan. 2025 | 10.00 AM
push_pin lock

Refresh ticket after trigger

(New Service) Is it possible to refresh a ticket after specific triggers has run for the ticket?  I need to remove the email headers from a new message before it displays and prevent the sendout of the message, so this is what i have come up with. In the trigger "Outbound email or SMS created" Copies the new message without the emailheaders and deletes it so I have an new message without the emailheaders. Prevents the sendout of the now deleted message.  I tried to do the copy message function in the "New External message on request" trigger, but that didn´t work cause when i tried to run the  NSTicketAgent. DeleteTicketMessageEntity  function does an "object not set to an instance of an object" error pop up and the ticket is undefined. The problem with trigger "Outbound email or SMS created" After the save does the messagelist contain both the new copied message and the old one. However when i do a refresh does the old message disappear.  So is there any way to refresh the ticket so that the old message gets removed properly?

FL

Fredrik Larsson
2
5
9. jan. 2025 | 01.26 PM
Emne:
Service and CRMScript Discussion

Seneste svar

Looks like there is not really any other solutions I can come up with unfortunately. Sequence of events makes it difficult.
by Michel Krohn-Dale
10. jan. 2025 | 09.26 AM
push_pin lock

crmscript online2 vs online4

Hi  i have a crmscript that works in a online4 enviroment. Trying to implement the same script in online2 customer doesnt work. Is there any differences on these two enviroment when it comes to crmscripts?   is there a way to see the uniqueid for the scripts? you have to put it in the button url..
Gabriel Wiig
2
1
8. jan. 2025 | 11.30 AM
Emne:
Service and CRMScript Discussion

Seneste svar

Define "doesn't work".
by Frode Lillerud
8. jan. 2025 | 11.32 AM
push_pin lock

WebTools auto login not working due to download service being offline/unavailable

We are having an issue with webtools auto login (double click on the owl in the tray area), it doesnt work and the log file shows the following: Error    2024-04-30T09:02:31.15    SuperOffice.TrayApp.Server.TrayAppServer>Execute<TRequest, TResponse> SuperOffice.TrayApp.TrayApp2.GetAlarmsRequest SuperOffice.TrayApp.Server.TrayAppServer+OnExecute`2[SuperOffice.TrayApp.TrayApp2.GetAlarmsRequest,SuperOffice.TrayApp.TrayApp2.GetAlarmsResponse] MSSQL - 12 \\\ 1501235947 SuperOffice 10.3.3 NetServer 10.3 Release (Build: Release_OnSite_10.3.3_2024.04.17-01) 10.3.0.0 10.3.3.617 Release_OnSite_10.3.3_2024.04.17-01 Default ACRMWEB02 NetServer        TrayAppServer.Execute implementation failed SuperOffice.TrayApp.TrayApp2.GetAlarmsRequest DH (1993) - Authorized (Employee)Gebruikersniveau 0+:  MSSQL - 12 \\ACRMSQL10\SuperOffice_AllCRM (crm_AllCRM), Database serial #: 1501235947, Database Expiration Date: Friday, July 12, 2024 ACRMSQL10 SuperOffice_AllCRM 1501235947 SuperOffice 10.3.3 NetServer 10.3 Release (Build: Release_OnSite_10.3.3_2024.04.17-01) 10.3.0.0 10.3.3.617 Release_OnSite_10.3.3_2024.04.17-01 Default ACRMWEB02 NetServer Response status code does not indicate success: 502 (Bad Gateway).    at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()    at SuperOffice.Util.HttpHelper.GetObjectFromHttpSyncWithContent[T](String url, HttpServiceJwtConfig config, RequestType requestType, HttpContent content)    at SuperOffice.DCF.Web.WebTools.WebToolsVersionService.GetVersionResponse(String clientVersion)    at SuperOffice.TrayApp.Server.TrayAppServer.ApplyVersioningRules[TResponse,TRequest](TResponse response, TRequest request)    at SuperOffice.TrayApp.Server.TrayAppServer.Execute[TRequest,TResponse](TRequest request, OnExecute`2 implementation) System.Net.Http           Exception Message:Response status code does not indicate success: 502 (Bad Gateway).       Exception Source:System.Net.Http       Exception Target:System.Net.Http.HttpResponseMessage EnsureSuccessStatusCode()          at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()          at SuperOffice.Util.HttpHelper.GetObjectFromHttpSyncWithContent[T](String url, HttpServiceJwtConfig config, RequestType requestType, HttpContent content)          at SuperOffice.DCF.Web.WebTools.WebToolsVersionService.GetVersionResponse(String clientVersion)          at SuperOffice.TrayApp.Server.TrayAppServer.ApplyVersioningRules[TResponse,TRequest](TResponse response, TRequest request)          at SuperOffice.TrayApp.Server.TrayAppServer.Execute[TRequest,TResponse](TRequest request, OnExecute`2 implementation)   The download service is offline, so i guess that is the underyling issue (https://www3-superoffice-com.azurewebsites.net/DownloadService/) WebTools should still work when this isn't available... SuperOffice Version: SuperOffice CRM OnSite 10.3 Release_OnSite_10.3.3_2024.04.17-01 WebTools version:   
David Hollegien
1
9
30. apr. 2024 | 07.05 AM
Emne:
Online development and web service API's

Seneste svar

Hi David, a new version (hotfix) of the DownloadService was pushed yesterday evening, we'll monitor it closely. Thank you for posting!
by Margrethe Romnes
8. jan. 2025 | 07.11 AM
push_pin lock

Stopping and starting the clock on a request via CRM Script

Hi All, I am trying to stop the clock on a request, when an internal user replies to the request and Continue the clock when the customer replies to the request, either by email or by the portal.  Support have confirmed this cannot be done in the standard system, and have suggested that I might be able to do this via a CRM Script.   I assume I can use the "New internal message on request" and "New external message on request" events, to either start or stop the clock, but I cannot find how to stop and start the clock via CRM Script.  Is this possible to do via scripting?   Many thanks,   Trevor
Trevor Sharp
1
3
12. dec. 2024 | 12.30 PM
Emne:
Service and CRMScript Discussion

Seneste svar

Hi Trevor, Escalation levels are completely independent of the timers. The request will escalate according to the escalation levels and timeouts no matter which status, or "clock" it is on. Unfortunately, for your needs. I believe there is no out-of-the-box solution that will solve what you are describing. Sorry. Sverre  
by Sverre Hjelm
6. jan. 2025 | 08.20 AM
push_pin lock

Number allocation when issuing POST call

Hello Everyone, I have a problem when issuing a API POST call to either the Person or Contact entity. Both entities make use of a so-called number allocation , but I seemingly cannot tap into  this functionality when issuing the call.  I have tried: Not specifying the field in the body that I post, hoping that the (next) number would be allocated automatically. It did not, unfortunately. It left the field blank, even though the settings specifies that the field cannot be blank. Specifying the field and its value in the body. I did this by first making a POST call to the GetRefCountEntity agent and getting the current value of the specific RefCountId then adding 1 to that number ("Number2") - the body would look like this (abbreviated): {   "Name": "MitTestFirma",   "OrgNr": "12341234",   "Number2": 35067,   "Emails": [     { ... etc etc } This method is not working either: When I query the GetRefCountEntity agent again after posting, the value has not changed for the specific entity. Does anyone have a suggestion on how to get this to work - if possible.   Thank you in advance and merry Christmas. Henrik
Henrik Povlsen
2
3
23. dec. 2024 | 10.19 AM
Emne:
Online development and web service API's

Seneste svar

Hi Henrik, Yes, but i would recommend that you use the full response of the /default call, and modify that based on your needs, since the /default call will do more then just the Number2 field (will also set default values from custom fields for example)
by David Hollegien
23. dec. 2024 | 10.34 AM
push_pin lock

Getting MergeMoveLog data

An app I have to update is written with use of primary id for person and contact, stored in an external system. It was done to speed things up, and to have an exact is instead of e.g. a name. So thats were things are now. But when a company is merge into another company or a person is moved, the id no longer exists of cause and I have to get the new id somehow. In SQL that is easy, somehow loop the mergemovelog table until the bottom starting with the old id, and getting the new id, and do it again until null if found. I can't find any api entry for the table, I could use the dynamic provider, and that is easy enough, but is there a api get for that table? (Maybe I could wish for a mergemovelog helper, with old id that returns the new id) So can someone help me and tell me if it is possible to make an api rest call for the table mergemovelog? Regards Martin
Martin Andersen
2
1
19. dec. 2024 | 04.00 PM
Emne:
Online development and web service API's

Seneste svar

No, there isn't an dedicated api/archive provider for the mergemovelog table, so this should be done with a dynamic query like you mentioned.
by David Hollegien
20. dec. 2024 | 08.42 AM