eQuipAPI

GetFactTableFieldData

The following routes are available for this service:
All Verbs	/GetFactTableFieldData

**GetFactTableFieldData** Parameters:
Name	Parameter	Data Type	Required
UserID	query	string	No
TransactionTableID	query	int	No
TransactionFactTableID	query	int	No
FilterResult	query	string	No
TableName	query	string	No
TransactionID	query	int	No
TableType	query	int	No
PkFieldID	query	int	No

**FactTableFieldDataResponse** Parameters:
Name	Parameter	Data Type	Required
TransactionID	body	int	No
TransactionTableID	body	int	No
FieldCollection	body	List<FactTableField>	No

**FactTableField** Parameters:
Name	Parameter	Data Type	Required
ID	body	int	No
Name	body	string	No
Display	body	string	No
Value	body	Object	No
Type	body	short	No
Text	body	string	No
FieldDataSource	body	List<Dictionary>	No
FieldValueQuery	body	string	No
PKField	body	string	No
ReadOnly	body	bool	No
IsEditForm	body	bool	No
FactFieldValidation	body	List<Dictionary>	No
FactTableFieldCollection	body	List<Column>	No
ValueList	body	bool	No
RealName	body	string	No
TransactionFieldID	body	int	No
AssetFieldMappedID	body	int	No
AssetFieldName	body	string	No
TransactionFieldType	body	int	No
UseMultiSelect	body	byte	No
Mandatory	body	bool	No
Hidden	body	bool	No
Format	body	int	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv

HTTP + JSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /jsv/reply/GetFactTableFieldData HTTP/1.1 
Host: equipstage3.e-isg.com 
Content-Type: text/jsv
Content-Length: length

{
	UserID: String,
	TransactionTableID: 0,
	TransactionFactTableID: 0,
	FilterResult: String,
	TableName: String,
	TransactionID: 0,
	TableType: 0,
	PkFieldID: 0
}

HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	TransactionID: 0,
	TransactionTableID: 0,
	FieldCollection: 
	[
		{
			ID: 0,
			Name: String,
			Display: String,
			Value: {},
			Type: 0,
			Text: String,
			FieldDataSource: 
			[
				{
					String: {}
				}
			],
			FieldValueQuery: String,
			PKField: String,
			ReadOnly: False,
			IsEditForm: False,
			FactFieldValidation: 
			[
				{
					String: {}
				}
			],
			FactTableFieldCollection: 
			[
				{
					field: String,
					command: String,
					selectable: False,
					title: String,
					template: String,
					format: String,
					decimals: 0,
					headerTemplate: String,
					locked: False,
					lockable: False,
					sortable: False,
					IsInlineEditWF: False,
					filterable: False,
					valueList: False,
					UseMultiSelect: False,
					Disable: False,
					Required: False,
					editor: String,
					type: String,
					TableType: String,
					width: 200,
					FieldDataSource: 
					[
						{
							String: {}
						}
					],
					expandable: False,
					FieldId: 0,
					ValueListType: 0,
					IsEditable: False,
					AssetMappedFieldID: 0,
					IsMaxLength: False,
					MaxLengthCount: 0,
					TextLength: 0
				}
			],
			ValueList: False,
			RealName: String,
			TransactionFieldID: 0,
			AssetFieldMappedID: 0,
			AssetFieldName: String,
			TransactionFieldType: 0,
			UseMultiSelect: 0,
			Mandatory: False,
			Hidden: False,
			Format: 0
		}
	]
}