SWS FIUSelect Method


Allows export of the FIU (Financial Integration Utility) general ledger data in .XML format to the accounting software. It can also be saved to a file path as long as permissions allow for it. This SWS method displays non-exported transaction data for the specified organization, sites and dates.

Parameters

Name DataType Is Required
EndDate DateTime Optional
Description The date to end a process. If start date is provided, then it is the end date of a range of dates. Technically, it’s one day beyond the end date. This date cannot be greater than today.
OrgID Long Required
Description The organization’s ID number.
Path String Not used for this method.
Description If entered, the file location where the FIU export data will be saved as a .xml file. Permissions for the directory must be set to allow this to occur.
SiteList Long Optional
Description A collection of limited site details for a specified site. This will return all sites within the organization if left undefined.
StartDate DateTime Required
Description The date to start a process. If end date is provided, then it is the start date of a range of dates.

Returned Parameters

Name DataType
TRAN_FIU_DATA TRAN_FIU_DATA
Description The object containing all the date for the call.

Example

As with every method we need to pass in credentials. We do this with the LookupUser request object.

We’ll assume you’ve got a web reference, let’s name it SWS, in your Visual Studio project.  At this point we need to our objects.  We’ll need the standard service object, a FIU_Request request object and a FIU_Response response object.  We can define and create those like this:

// Create a request and response objects
SWS.WSSoapClient service = new SWS.WSSoapClient();
SWS.FIU_Request request = new SWS.FIU_Request();
SWS.FIU_Response response;

Here’s my sample code of the Request object.

// FIUSelect Request
request.OrgID = 123456;
request.SiteList = new long[] { 123456, 456789 };
request.StartDate = DateTime.Today.AddDays(1);
request.EndDate = DateTime.Today;

Finally we can call the method and pass across the login object and the request object to update our previously exported financial information. It’s a good idea to do this in a Try Catch block.

// Call the method that will load the response object
try
{
  response = service.FIUSelect(user_request,request);
}
catch (Exception ex)
{
  MessageBox.Show(ex.Message);
}

Note that if something goes wrong the service will respond with an exception. You’ll want to take a look at that message returned in that exception so it can be debugged.

For a full list of methods see SWS Methods.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: