Home > API General, Data Carve > BulkData GetCarveData Method

BulkData GetCarveData Method


Retrieves data from the carve for a date range not to exceed a total of 48 hours. This returns the table’s columns to create a table in your database and any records created or updated in the time range and table requested. To use this method the organization must have access to the carve and the API user must have permissions to the carve data.

Parameters

Name Data Type Is Required
OrgID Long Required
Description The organization’s ID number.
TableName String Required
Description The name of the table you wish to retrieve from the carve data. See the GetCarveTableList method for a list of available tables.
BeginDate DateTime Required
Description The beginning date of the date range for which to pull the list of new accounts. This date cannot be more then 96 hours in the past.
EndDate DateTime Optional
Description The end date of the date range for which to pull the list of new accounts. This will default to SYSDATE if left undefined.
SiteID Long Required
Description The site’s ID number. This can be found using the GetSiteList method.

Returned Parameters

Name Data Type
Table Elements List Collection
Description This is the list of columns within the table requested. See GetCarveTableList for additional details.
Table Data Collection
Description The data that is within the requested carve table. See GetCarveTableList for additional details.

Example

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

// Create request objects
BulkData.LookupUser_Request user_request = new BulkData.LookupUser_Request();
BulkData.BulkDataSoapClient service = new BulkData.BulkDataSoapClient();
BulkData.GetCarveData_Request request = new BulkData.GetCarveData_Request();

Here’s my sample code of the Request and user objects.

// request
user_request.Username = "user";
user_request.Password = "pass";
user_request.Channel = 999;

request.OrgID = 123546;
request.BeginDate = 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 retrieve our data. It’s a good idea to do this in a Try Catch block.

// Call the method that will load the response object
try
{
  System.Data.DataTable response;
  response = service.GetCarveData(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 BulkData Methods.

Categories: API General, Data Carve
  1. swsBecky
    April 24, 2017 at 3:26 pm

    Update July 10, 2013: There is a new carve view that can be pulled to retrieve tran_efunds data when using the GetCarveData method. You do have to have permission to the 4.0 data carve. The new name is CRV_TRAN_EFUNDS_V. This new view is also part of the GetCarveTableList method. Field names are :
    – EFUND_ID (xs:long)
    – ACCT_ID (xs:long)
    – SITE_ID (xs:long)
    – FUND_AMT (xs:double)
    – FUND_STATUS (xs:short)
    – FUND_STATUS_VAL (xs:string)
    – FUND_AUTH (xs:string)
    – FUND_INFO (xs:string)
    – FUND_TYPE (xs:decimal)
    – FUND_TYPE_VAL (xs:string)
    – LASTFOUR (xs:string)
    – CREATED_DATE (xs:dateTime)
    – CREATED_PID (xs:long)
    – CREATED_NAME (xs:string)
    – UPDATED_DATE (xs:dateTime)
    – UPDATED_PID (xs:long)
    – UPDATED_NAME (xs:string)
    – ORG_ID (xs:long)

    *The fund_type in this table is an amalgamation of data points from both Centershift and the credit card Processor. We recommend that this information be paired with tran_pay (join on efund_id) and the tran_pay.pay_method be referenced to find the type of credit card transaction.

  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: