GetContent

Description

Returns a DatabaseContent containing the database designer content data.

Maximum page size is 2000. If you need to retrieve the whole table and it exceeds 2000, you will need to do it pages of 2000.
Signature
DatabaseContent GetContent(string key, int tableId, int pageSize, string lastPageId, BrowseListDirection direction,  bool getRunTimeContent, string[] ids)

Parameters

Name Data Type Description

key

string required

The authentication key

tableId

int required

The table id for the database designer table.

pageSize

int required

The number of rows requested.

lastPageId

string

Use Null to start from the beginning. For paging, use the last id from the previous query.

direction

The direction to retrieve the next page.

getRunTimeContent

bool required

True to get run time content, False to get design time content.

ids

string[]

Filter with the specified ids. Use null to disable filtering.

Response

Data Type Description

The database content for the requested table.

Example

// Create instance of the webservice
var designer = new DatabaseDesignerSoapClient();
//***************************************************
//
// GetContent
//
//***************************************************

int tableId = 3;
int pageSize = 30;

// Gets a page of 30 rows (maximum) in runtime mode.
DatabaseContent content = designer.GetContent(key, tableId, pageSize, null, BrowseListDirection.Next, true, null);

// If we have more content, get the next page
if (!content.AtEnd)
{
	string lastId = content.Rows[content.Rows.Length - 1].Id;
	DatabaseContent contentPage2 = designer.GetContent(key, tableId, pageSize, lastId, BrowseListDirection.Next, true, null);
}

// Get specific rows in design time mode
string[] ids = new string[] { "client1", "client2", "client3", "client4" };
DatabaseContent specificContent = designer.GetContent(key, tableId, 4, null, BrowseListDirection.Next, false, ids);