List of Orders

[dmalhotra]

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

[Mark McKenna]

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.

[roteague]

Any idea of timeframe or version where the MSMQ functionality will be added to the EventNotification service?

[Mark McKenna]

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.

[roteague]

Thanks Mark, MSMQ is a great solution. I've been advocating it around here for sometime.