Page Comparison

LIVE: http://api.relateddigital.com/resta/api/datawarehouse/querymemberdatawarehouse

ECOMM: http://api.relateddigital.com/reste/api/datawarehouse/querymemberdatawarehouse

POST

Content-Type: application/json

Authorization: The ticket given by the system after successfull login

DwTableName (string): Data Warehouse table name,

KeyColumn : This can be EMAIL, MEMBER_ID or any column the developer wants like Name, Surname as configured by using Euro.Message admin panel

Values(string[]): Value list ,

PageNumber :Total number of page to be displayed

PageSize : otal number of data to be displayed

{
"DwTableName":"",

"KeyColumn" : " ",

"Values":["",""],

"PageNumber":1,

"PageSize":100
}

{
"Table": [
{
"ADSOYAD": "Example Field",
"DOGUMTARIHI": "Example Field",
"EMAIL": "Example Field",
"GENDER": "Example Field",
"KEY_ID": "Example Field",
"STATUS": "A",
"EMAIL_PERMIT": "Y",
"GSM_PERMIT": "Y",
"FAX_PERMIT": "Y",
"CALL_PERMIT": "Y",
"PRINT_PERMIT": "Y"
}
],
"Success": true,
"Errors": [],
"DetailedMessage": "",
"TransactionId": "5DEE772501F541C9926082A2BB93DEE2"
}

Status Code: 200

Status Code: 400 Bad Request

Status Code: 401 Unauthorized

00, 01, 06,14,35,36,37,38,40, 47, 79, 92, 99, 107

LIVE: http://api.relateddigital.com/resta/api/datawarehouse/GetFLTableColumnsquerymemberdatawarehouse

ECOMM: http://api.relateddigital.com/reste/api/datawarehouse/GetFLTableColumnsquerymemberdatawarehouse

POST

Content-Type: application/json

Authorization: The ticket given by the system after successfull login

DwTableName (string): Data Warehouse table name

{
"DwTableName":""

}

{
"Columns": [
{
"ColumnName": "EMAIL",
"ColumnType": "Alphanumeric",
"Visible": true,
"Required": false,
"ColumnTypeDetail": "string(80)"
}
],
"Success": true,
"Errors": [],
"DetailedMessage": "",
"TransactionId": "AF5EF87B0F7A41629D438698DC92023A"
}

Status Code: 200

Status Code: 400 Bad Request

Status Code: 401 Unauthorized

00, 01, 06,14,35,36,37,38,40, 47, 79, 92, 99, 107