Post Syspro QueryQuery
Is a connector designed to be used for any Syspro Query function in the E.Net catalogue. The connector input file must match the query parameter file. you can then use this connector to push in and query Syspro for the results. _meta field on the incoming document will be saved on the response document. Note: that usually Syspro only allows one instance of the user to be logged in at one time, so be careful to ensure poling is staggered correctly to avoid 2 publishers running at the same time, with the same user. Please see Examples for recommended Syspro workflows. Inputs:
Operator Name: This is a Syspro Login User
Password: The Password that is associated with the user above
CompanyId: The Syspro company Id for the instance you would like to publish the document to.
Company Password: The Password that is associated with the company above
SYSPROWCFBinding: Selecting Binding type from the dropdown provided
BusinessObject: the E.Net business object name
Test URL: The URL of the test E.Net WCF service (if utopia is connecting from outside the network, this will need to be public. If you are just using a test company then this will match production) Production URL: The URL of the production E.Net WCF service (if utopia is connecting from outside the network, this will need to be public)
Production Service: Yes/No dropdown to toggle between the two URL’s
Invoice Collection: Choose the Collection you would like the response to be saved to.
Lookup Date Format: date formats you wish to convert. Generally, Utopia uses date formats as per this example:
Replacement Date Format: Syspro generally does not accept time, so you can update the date format to the following if required:
Cancel Retry Intervals: This function will enable to the connector to keep poling until it finds a successful response. This arose from querying Syspro for invoice information when you only have a sales order number, so the connector would need to keep retrying the query until the invoice was generated and the query successful. Having this open ended is problematic, so you can set a poling time here. It will keep poling until the time has completed and if it is still unsuccessful it will create an error.
Last updated