Page Comparison

LIVE: https://api.relateddigital.com/resta/api/Datawarehouse/InsertUpdateRowInDwTable

ECOMM: https://api.relateddigital.com/reste/api/Datawarehouse/InsertUpdateRowInDwTable

LIVEB: https://api.relateddigital.com/rest_livebliveb_rest/api/Datawarehouse/InsertUpdateRowInDwTable

LIVEM: https://api.relateddigital.com/restm/api/Datawarehouse/InsertUpdateRowInDwTable

POST

Content-Type: application/json

Authorization: The ticket given by the system after successfull login.

DwTableName(string): Data Warehouse table name

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

Value(string): This is the value of the Key Column. İf this value sent in wrong format, its ignored and the main process is not interrupted.

ForceUpdate(bool): If Key and Value pinpoint an existing member, then instead of insertion, the function decide to update it or not. If this flag is true, it updates the member by using the demographic information provided. Otherwise, give Code not equal 00 back and put Already existing member in Message.

DemographicData(KeyValue []): This is an KeyValue array. In short, keys and values which composes the demographic information.

InsertEmptyValueForNonDemographicColumns(bool): if flag is true, inserting empty value instead of nondemographic columns. Otherwise, give code not equal 00 back and put column number does not match in Message.

{

"DwTableName" : "",

"Key" : "",

"Value" : "",

"ForceUpdate" : false,

"DemographicData" :

      [

           { "Key" : "", "Value": ""}     

      ],

"InsertEmptyValueForNonDemographicColumns": false

}

{

"MemberId": ""

"Success": false,

  "Errors": [

    {

      "Code": "",

      "Message": ""

    }

  ],

"DetailedMessage": ""

"TransactionId": ""

}

Status Code: 200

Status Code: 400 Bad Request

Status Code: 401 Unauthorized

00, 01, 06,14,18,19,25,35,36,37,38,40, 47, 79, 92, 99, 107, 117

LIVE: https://api.relateddigital.com/resta/api/Datawarehouse/UploadDataWarehouseFile

ECOMM: https://api.relateddigital.com/reste/api/Datawarehouse/UploadDataWarehouseFile

LIVEB: https://api.relateddigital.com/rest_livebliveb_rest/api/Datawarehouse/UploadDataWarehouseFile

LIVEM: https://api.relateddigital.com/restm/api/Datawarehouse/UploadDataWarehouseFile

POST

Content-Type: application/json

Authorization: The ticket given by the system after successfull login

FileName (string): Name of file which is used for saving file.

FileContent (byte []): File content should be converted to byte array.

FileExtensionType (int): File is saved with this extension. System allows three extensions. Txt is 1, zip is 2 and csv is 3

(Ex: FileName=test,FileExtensionType=1-> file saved as test.txt)

{

"FileName" : "",

"FileContent" : "",

"FileExtensionType" : 1

}

{

"Success": false,

  "Errors": [

    {

      "Code": "",

      "Message": ""

    }

  ],

"DetailedMessage": ""

"TransactionId": ""

}

Status Code: 200

Status Code: 400 Bad Request

Status Code: 401 Unauthorized

00, 01, 83, 84, 99, 132

LIVE: https://api.relateddigital.com/resta/api/Datawarehouse/BulkInsertUpdateRowInDwTable

ECOMM: https://api.relateddigital.com/reste/api/Datawarehouse/BulkInsertUpdateRowInDwTable

LIVEB: https://api.relateddigital.com/rest_livebliveb_rest/api/Datawarehouse/BulkInsertUpdateRowInDwTable

LIVEM: https://api.relateddigital.com/restm/api/Datawarehouse/BulkInsertUpdateRowInDwTable

POST

Content-Type: application/json

Authorization: The ticket given by the system after successfull login

DwTableName (string): Data Warehouse table name

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

MemberList (List<Member>): Member list which can be inserted or updated

Member:

KeyColumnValue(string): This is the value of the Key Column. İf this value sent in wrong format, its ignored and the main process is not interrupted.

DemographicData(KeyValue []): This is an KeyValue array. In short, keys and values which composes the demographic information.

{

  "DwTableName" : "pgp_data",

  "KeyColumn" : "KEY_ID",

  "MemberList" :

  [       

                {

                               "DemographicData":

                                                                 [     

                                                               {"Key" : "NAME", "Value" : ""}

                                                                 ],

                                 "KeyColumnValue" : " "

                },

                {

                               "DemographicData":

                                                                 [     

                                               {"Key" : "EMAIL", "Value" : ""} ,

                                               {"Key" : "COL_INT", "Value" : "22"}

                                                                 ],

                              "KeyColumnValue " : " "

                }

  ]

}

{

"Success": false,

  "Errors": [

    {

      "Code": "",

      "Message": ""

    }

  ],

"DetailedMessage": ""

"TransactionId": ""

}

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: https://api.relateddigital.com/resta/api/datawarehouse/querymemberdatawarehouse

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

LIVEB: https://api.relateddigital.com/rest_livebliveb_rest/api/datawarehouse/querymemberdatawarehouse

LIVEM: https://api.relateddigital.com/restm/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: https://api.relateddigital.com/resta/api/datawarehouse/querymemberdatawarehouse

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

LIVEB: https://api.relateddigital.com/rest_livebliveb_rest/api/datawarehouse/querymemberdatawarehouse

LIVEM: https://api.relateddigital.com/restm/api/datawarehouse/querymemberdatawarehouse

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

LIVE: https://api.relateddigital.com/resta/api/datawarehouse/UpdateDwTableExpireDate

ECOMM: https://api.relateddigital.com/reste/api/datawarehouse/UpdateDwTableExpireDate

LIVEB: https://api.relateddigital.com/rest_livebliveb_rest/api/datawarehouse/UpdateDwTableExpireDate

LIVEM: https://api.relateddigital.com/restm/api/datawarehouse/UpdateDwTableExpireDate

POST

Content-Type: application/json

Authorization: The ticket given by the system after successfull login

DwTableName (string): Data Warehouse table name

NewDate (DateTime): Expire date

{
"DwTableName":"",

"NewDate":""

}

{
"CurrentDate": "2019-12-30T00:00:00",
"Success": true,
"Errors": [],
"DetailedMessage": "",
"TransactionId": "D1F5FF8489EF4F6D83AC7D743A56FD73"
}

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,142,143

LIVE: https://api.relateddigital.com/resta/api/Datawarehouse/SelectRowsFromDwTable

ECOMM: https://api.relateddigital.com/reste/api/Datawarehouse/SelectRowsFromDwTable

LIVEB: https://api.relateddigital.com/rest_livebliveb_rest/api/Datawarehouse/SelectRowsFromDwTable

LIVEM: https://api.relateddigital.com/restm/api/Datawarehouse/SelectRowsFromDwTable

POST

Content-Type: application/json

Authorization: The ticket given by the system after successfull login

DwTableName(string): Data Warehouse table name

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

Value(string): This is the value of the Key Column. İf this value sent in wrong format, its ignored and the main process is not interrupted.

Sample:

{

  "DwTableName": "sample string 1",

  "Key": "sample string 2",

  "Value": "sample string 3"

}

{
"MemberId": ""

"Success": false,

  "Errors": [

    {
      "Code": "",

      "Message": ""
    }
  ],
"DetailedMessage": ""

"TransactionId": ""
}

Status Code: 200

Status Code: 400 Bad Request

Status Code: 401 Unauthorized

00, 01, 06,14,18,19,25,35,36,37,38,40, 47, 79, 92, 99, 107, 117