Mike,

There was a similar question regarding this asked over a year ago and below were some recommendations:

There are several ways you can do this. 

1) The easiest way would be to utilize the import/export templates, and export the data to a delimited text file. 

2) Utilize the X3 objects, and publish them as web services, and read the objects using a query to get the left list, and a read to get all of the object details.  This method doesn't offer as many options for filtering the data you are pulling.

3) Create a custom sub-program using the X3 4GL, and publish it as a web service.  This provides more flexibility on filtering the data you want to extract, and also on the fields that are returned. 

I often do options #2 and #3, and consume the web services from a .net application, then push the data to an external/3rd party application.

The method you do really depends upon how often you want to do this.  If it's a one-time thing, I would do option 1.  If you intend on setting up an ongoing process to pull data, I would do option 2 or 3.

Mike,

There was a similar question regarding this asked over a year ago and below were some recommendations:

There are several ways you can do this. 

1) The easiest way would be to utilize the import/export templates, and export the data to a delimited text file. 

2) Utilize the X3 objects, and publish them as web services, and read the objects using a query to get the left list, and a read to get all of the object details.  This method doesn't offer as many options for filtering the data you are pulling.

3) Create a custom sub-program using the X3 4GL, and publish it as a web service.  This provides more flexibility on filtering the data you want to extract, and also on the fields that are returned. 

I often do options #2 and #3, and consume the web services from a .net application, then push the data to an external/3rd party application.

The method you do really depends upon how often you want to do this.  If it's a one-time thing, I would do option 1.  If you intend on setting up an ongoing process to pull data, I would do option 2 or 3.

Hi Rafael, many thanks for the prompt response and suggestions!

The web services option makes sense as we're probably looking at a nightly feed, I'm just surprised that there doesn't seem to be much information on any of the sites I found with respect to data extracts apart from excel dumps and Salesforce interaction.

Once again, much appreciated!

Mike