eQuipAPI

<back to all web services

GetMappingTableFieldData

The following routes are available for this service:
All Verbs/GetMappingTableFieldData
GetMappingTableFieldData Parameters:
NameParameterData TypeRequiredDescription
UserIDquerystringNo
TableIDqueryintNo
FilterResultquerystringNo
MappingTableNamequerystringNo
AssetIDqueryintNo
MappingTableFieldDataResponse Parameters:
NameParameterData TypeRequiredDescription
AssetIDbodyintNo
FieldCollectionbodyList<workflowField>No
workflowField Parameters:
NameParameterData TypeRequiredDescription
IDbodyintNo
NamebodystringNo
DisplaybodystringNo
ValuebodyObjectNo
TextbodystringNo
TypebodyshortNo
valuelistTypebodyshortNo
FieldDataSourcebodyList<Dictionary>No
HolidingFieldNamebodystringNo
HolidingFieldEditbodystringNo
FieldValueQuerybodystringNo
MappingTablebodystringNo
ReadOnlybodystringNo
MappingPKFieldbodystringNo
MappingTableDisplayReadOnlybodyboolNo
IsEditFormbodyboolNo
MappingFieldValidationbodyList<Dictionary>No
MappingFieldbodyList<Column>No
MandatorybodystringNo
BulkUpdateFieldbodyboolNo
MaxLengthbodyintNo
ValueListbodyboolNo
hiddenbodystringNo
RealNamebodystringNo
AssetMappedFDIDbodyintNo
DisablebodystringNo
RequiredbodystringNo
UseMultiSelectbodybyteNo
IsMaskbodyboolNo
DisplayMaskbodystringNo
MaskStartbodyintNo
MaskEndbodyintNo
FormatbodystringNo

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/GetMappingTableFieldData HTTP/1.1 
Host: equipstage2.e-isg.com 
Content-Type: text/jsv
Content-Length: length

{
	UserID: String,
	TableID: 0,
	FilterResult: String,
	MappingTableName: String,
	AssetID: 0
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	AssetID: 0,
	FieldCollection: 
	[
		{
			ID: 0,
			Name: String,
			Display: String,
			Value: {},
			Text: String,
			Type: 0,
			valuelistType: 0,
			FieldDataSource: 
			[
				{
					String: {}
				}
			],
			HolidingFieldName: String,
			HolidingFieldEdit: String,
			FieldValueQuery: String,
			MappingTable: String,
			ReadOnly: String,
			MappingPKField: String,
			MappingTableDisplayReadOnly: False,
			IsEditForm: False,
			MappingFieldValidation: 
			[
				{
					String: {}
				}
			],
			MappingField: 
			[
				{
					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
				}
			],
			Mandatory: String,
			BulkUpdateField: False,
			MaxLength: 0,
			ValueList: False,
			hidden: String,
			RealName: String,
			AssetMappedFDID: 0,
			Disable: String,
			Required: String,
			UseMultiSelect: 0,
			IsMask: False,
			DisplayMask: String,
			MaskStart: 0,
			MaskEnd: 0,
			Format: String
		}
	]
}