RangerMSP Business Automation for successful ITs

 
October 5th, 2015, 10:02 AM
fabrizio.dicesare
 
Posts: 29
Hi,

I need to insert a new Contract via Web API, but as far as I can see all the properties of the Contract object are read only. Is there a way of insert a new Contract or this is a web api limitation?

Thanks,

Fabrizio
 
October 5th, 2015, 10:04 AM
Support Team
 
Posts: 7,510
Thank you for asking. At this time new Contracts cannot be added using the API. Thank you for asking, we'll take a note of this.
 
October 5th, 2015, 10:13 AM
fabrizio.dicesare
 
Posts: 29
Thanks for your quick reply. Is there any other way (e.g. ODBC) to add Contracts programmatically or the only way of inserting contract by now is manually?
 
October 5th, 2015, 10:22 AM
Support Team
 
Posts: 7,510
You're welcome. Nope, with ODBC you can query data but you should never use it to insert. Thanks!
 
October 6th, 2015, 01:39 AM
fabrizio.dicesare
 
Posts: 29
I am really sorry, but I have to insist. We need to insert about two thousand contracts and we'd strongly prefer to do it automatically. It is a bulk operation that we have to do only once.

So, I have two more questions for you about our problem:

1) Can we insert Contracts just once directly via db? If we cannot, could you please further explain what is the problem in doing it via db INSERT statements?

2) If we can do those INSERT commands via db (just once), can you show us how to generate some correct REC_IDs for the new Contracts?

Thanks a lot,

Fabrizio
 
October 6th, 2015, 06:06 AM
Support Team
 
Posts: 7,510
Thank you for asking again. Unfortunately the answer is still no :( The API supports many different entities of RangerMSP (Accounts/Items/Charges/Appointments/Tasks/Tickets/Quotes/Etc...) however not Contracts and you should never ever perform any direct database operation. This will end up breaking the integrity of the system and might cause numerous issues.

In case the Contracts repeat themselves then in RangerMSP you can create one Contract with all details and then use the Copy option to copy it to other Accounts, this should be a time saver.

Hope this helps.
 
December 16th, 2019, 03:58 AM
fabrizio.dicesare
 
Posts: 29
Hi all,

any news about this issue? We have to insert thousands of contracts again and we are looking for a way to do it automatically (or less manually, at least :)

Thanks

Fabrizio
 
December 16th, 2019, 06:39 AM
Support Team
 
Posts: 7,510
Thank you for posting this.

The Web API supports adding many different entity types, however, it does not support adding Contracts at this time.

We may be able to offer you an unofficial access to a low level API that will support adding Contracts, however we need to learn more about your requirement.

We recommend that you email us (support @ ) the complete list of fields you intend to pass when creating the new contract, the exact type of contract you want to create. We will review the information and will back to you with the update.

Hope this helps.
 
December 17th, 2019, 05:58 PM
adent-ctc
 
Posts: 62
We would also like to see the official CommitCRM API support creation and updating contract records.
 
January 19th, 2020, 03:45 PM
Lampson_sec
 
Posts: 39
Let me ALSO request this.

Not ONLY this, but I'd request that CommitCRM move to delivering API first, or "as-a-first-class-citizen" development approach:

https://nordicapis.com/sessions/deli...class-citizen/

We shouldn't have to "ASK" for access to functions in the application, it should be our choice on how to get something done, either in the API, UI, import, or webUI... but really you should be able to do everything with the API.

Also, don't mean to pile-on, but it desperately needs to be a modern RESTful WEB API. this is 2020 after all, and the current API is not fun to work with at all...
 
January 20th, 2020, 06:02 AM
Support Team
 
Posts: 7,510
Thank you for your feedback. Noted.
 
February 4th, 2020, 02:18 PM
adent-ctc
 
Posts: 62
If the CommitCRM API is replaced with something more modern, consider gRPC.

Google designed gRPC and then open sourced it.
Microsoft are on board.
https://docs.microsoft.com/en-us/asp...aspnetcore-3.1

As is Netflix, Dropbox etc
https://medium.com/@sankar.p/how-grp...t-30408bf42794
https://www.cncf.io/netflix-case-study/
https://code.tutsplus.com/tutorials/...pis--cms-30711
https://www.yonego.com/nl/why-milliseconds-matter/#gref
 
February 5th, 2020, 06:00 AM
Support Team
 
Posts: 7,510
Thank you.
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search



All times are GMT -6. The time now is 05:04 AM.

Archive - Top    

RangerMSP - A PSA software designed for MSPs and IT Services Providers
Forum Software Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.