We are trying to link SoftPro with another system for which we need to get list of orders which can be imported to new system db.
For that we are looking for an API which can give a list of orders in the system which are modfied since specific date time. In the start we can start we can specifiy any minimum date like 1/1/1960 etc. to get list of all orders and there after we will specify date time as the time we sync up orders last time.
We looked at event subsription method but there are two problems with that:
1) How do get list of orders which are already there in system
2) In case of network issue or client updrade (whcih is listening to notifications) we will lose nofification data unless there's option to log notifications to any medium like DB or MSSQ
Is there any way to achieve the same?
Regards,
Deepak Malhotra
List of Orders
Re: List of Orders
Hi Deepak,
The current API does not provide a means by which to query for all orders in the system. The only way to get the information you need is by querying the database directly, which is generally not recommended except when absolutely necessary, as it appears to be in this case. A future release of Select is expected to provide the information you are looking for at the API level.
As for event notifications, you are right - the system only provides notifications for the open order in which the event occurs. Currently, only email and web service delivery options are supported, although we are actively developing an MSMQ variation that is expected to appear in our next major release. In the current setup, failed deliveries remain in the notification queue and are retried periodically, so although that doesn't provide true guaranteed delivery (ensuring sequence, etc.) it might still be reliable enough for your purpose. When the MSMQ variation rolls out, it alone will provide guaranteed delivery in the order that events occur, and at that time the email and web service delivery options will revert to a try-once effort and immediately removed from the queue.
The current API does not provide a means by which to query for all orders in the system. The only way to get the information you need is by querying the database directly, which is generally not recommended except when absolutely necessary, as it appears to be in this case. A future release of Select is expected to provide the information you are looking for at the API level.
As for event notifications, you are right - the system only provides notifications for the open order in which the event occurs. Currently, only email and web service delivery options are supported, although we are actively developing an MSMQ variation that is expected to appear in our next major release. In the current setup, failed deliveries remain in the notification queue and are retried periodically, so although that doesn't provide true guaranteed delivery (ensuring sequence, etc.) it might still be reliable enough for your purpose. When the MSMQ variation rolls out, it alone will provide guaranteed delivery in the order that events occur, and at that time the email and web service delivery options will revert to a try-once effort and immediately removed from the queue.
Re: List of Orders
Any idea of timeframe or version where the MSMQ functionality will be added to the EventNotification service?
Robert
Re: List of Orders
Hi Robert, MSMQ delivery support is currently part of our next major release cycle (v2.7). I don't think we have an official release date for this version yet, however.
Re: List of Orders
Thanks Mark, MSMQ is a great solution. I've been advocating it around here for sometime.
Robert