Data Warehouse Service

On this Page:

InsertUpdateRowInDwTable

URL	LIVE: https://api.relateddigital.com/resta/api/Datawarehouse/InsertUpdateRowInDwTable ECOMM: https://api.relateddigital.com/reste/api/Datawarehouse/InsertUpdateRowInDwTable LIVEB: https://api.relateddigital.com/liveb_rest/api/Datawarehouse/InsertUpdateRowInDwTable LIVEM: https://api.relateddigital.com/restm/api/Datawarehouse/InsertUpdateRowInDwTable
Http verb	POST
Parameters
Header	Content-Type: application/json Authorization: The ticket given by the system after successfull login.
Body	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, function doesn't update the member. DemographicData(KeyValue []): This is a 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 to 00 back and put column number does not match in Message.
Sample Body	{ "DwTableName" : "Name of the uploaded DWH file", "Key" : "Reference; EMAIL or KEY_ID", "Value" : "Reference value", "ForceUpdate" : true, "DemographicData" : [ { "Key" : "NAME", "Value": "John"} ], "InsertEmptyValueForNonDemographicColumns": true }
Sample Response	{ "MemberId": "" "Success": false, "Errors": [ { "Code": "", "Message": "" } ], "DetailedMessage": "" "TransactionId": "" }
Success Response	Status Code: 200
Http Error Response	Status Code: 400 Bad Request Status Code: 401 Unauthorized
Error Code	00, 01, 06,14,18,19,25,35,36,37,38,40, 47, 79, 92, 99, 107, 117

UploadDataWarehouseFile

URL	LIVE: https://api.relateddigital.com/resta/api/Datawarehouse/UploadDataWarehouseFile ECOMM: https://api.relateddigital.com/reste/api/Datawarehouse/UploadDataWarehouseFile LIVEB: https://api.relateddigital.com/liveb_rest/api/Datawarehouse/UploadDataWarehouseFile LIVEM: https://api.relateddigital.com/restm/api/Datawarehouse/UploadDataWarehouseFile
Http verb	POST
Parameters
Header	Content-Type: application/json Authorization: The ticket given by the system after successfull login
Body	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)
Sample Body	{ "FileName" : "", "FileContent" : "", "FileExtensionType" : 1 }
Sample Response	{ "Success": false, "Errors": [ { "Code": "", "Message": "" } ], "DetailedMessage": "" "TransactionId": "" }
Success Response	Status Code: 200
Http Error Response	Status Code: 400 Bad Request Status Code: 401 Unauthorized
Error Code	00, 01, 83, 84, 99, 132

BulkInsertUpdateRowInDwTable

URL	LIVE: https://api.relateddigital.com/resta/api/Datawarehouse/BulkInsertUpdateRowInDwTable ECOMM: https://api.relateddigital.com/reste/api/Datawarehouse/BulkInsertUpdateRowInDwTable LIVEB: https://api.relateddigital.com/liveb_rest/api/Datawarehouse/BulkInsertUpdateRowInDwTable LIVEM: https://api.relateddigital.com/restm/api/Datawarehouse/BulkInsertUpdateRowInDwTable
Http verb	POST
Parameters
Header	Content-Type: application/json Authorization: The ticket given by the system after successfull login
Body	DwTableName (string): Data Warehouse table name KeyColumn(string): This can be EMAIL or KEY_ID MemberList (List<Member>): Member list which can be inserted or updated Member: KeyColumnValue(string): This is the value of the Key Column. If this value sent in wrong format, its ignored and the main process is not interrupted. DemographicData(KeyValue []): This is a KeyValue array. In short, keys and values which composes the demographic information.
Sample Body	{ "DwTableName":"BulkerTest3", "KeyColumn":"EMAIL", "MemberList":[ { "KeyColumnValue":"abdullahdarcin@euromsg.com", "DemographicData":[ { "Key":"NAME", "Value":"Abdullah" } ] }, { "KeyColumnValue":"abdullah.darcin@euromsg.com", "DemographicData":[ { "Key":"NAME", "Value":"Abdullah" } ] } ] }
Sample Response	{ "Success": false, "Errors": [ { "Code": "", "Message": "" } ], "DetailedMessage": "" "TransactionId": "" }
Success Response	Status Code: 200
Http Error Response	Status Code: 400 Bad Request Status Code: 401 Unauthorized
Error Code	00, 01, 06,14,35,36,37,38,40, 47, 79, 92, 99, 107

QueryMemberDatawarehouse

URL	LIVE: https://api.relateddigital.com/resta/api/datawarehouse/querymemberdatawarehouse ECOMM: https://api.relateddigital.com/reste/api/datawarehouse/querymemberdatawarehouse LIVEB: https://api.relateddigital.com/liveb_rest/api/datawarehouse/querymemberdatawarehouse LIVEM: https://api.relateddigital.com/restm/api/datawarehouse/querymemberdatawarehouse
Http verb	POST
Parameters
Header	Content-Type: application/json Authorization: The ticket given by the system after successfull login
Body	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
Sample Body	{ "DwTableName":"", "KeyColumn" : " ", "Values":["",""], "PageNumber":1, "PageSize":100 }
Sample Response	{ "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" }
Success Response	Status Code: 200
Http Error Response	Status Code: 400 Bad Request Status Code: 401 Unauthorized
Error Code	00, 01, 06,14,35,36,37,38,40, 47, 79, 92, 99, 107

GetFLTableColumns

URL	LIVE: https://api.relateddigital.com/resta/api/datawarehouse/querymemberdatawarehouse ECOMM: https://api.relateddigital.com/reste/api/datawarehouse/querymemberdatawarehouse LIVEB: https://api.relateddigital.com/liveb_rest/api/datawarehouse/querymemberdatawarehouse LIVEM: https://api.relateddigital.com/restm/api/datawarehouse/querymemberdatawarehouse
Http verb	POST
Parameters
Header	Content-Type: application/json Authorization: The ticket given by the system after successfull login
Body	DwTableName (string): Data Warehouse table name
Sample Body	{ "DwTableName":"" }
Sample Response	{ "Columns": [ { "ColumnName": "EMAIL", "ColumnType": "Alphanumeric", "Visible": true, "Required": false, "ColumnTypeDetail": "string(80)" } ], "Success": true, "Errors": [], "DetailedMessage": "", "TransactionId": "AF5EF87B0F7A41629D438698DC92023A" }
Success Response	Status Code: 200
Http Error Response	Status Code: 400 Bad Request Status Code: 401 Unauthorized
Error Code	00, 01, 06,14,35,36,37,38,40, 47, 79, 92, 99, 107

UpdateDwTableExpireDate

URL	LIVE: https://api.relateddigital.com/resta/api/datawarehouse/UpdateDwTableExpireDate ECOMM: https://api.relateddigital.com/reste/api/datawarehouse/UpdateDwTableExpireDate LIVEB: https://api.relateddigital.com/liveb_rest/api/datawarehouse/UpdateDwTableExpireDate LIVEM: https://api.relateddigital.com/restm/api/datawarehouse/UpdateDwTableExpireDate
Http verb	POST
Parameters
Header	Content-Type: application/json Authorization: The ticket given by the system after successfull login
Body	DwTableName (string): Data Warehouse table name NewDate (DateTime): Expire date
Sample Body	{ "DwTableName":"", "NewDate":"" }
Sample Response	{ "CurrentDate": "2019-12-30T00:00:00", "Success": true, "Errors": [], "DetailedMessage": "", "TransactionId": "D1F5FF8489EF4F6D83AC7D743A56FD73" }
Success Response	Status Code: 200
Http Error Response	Status Code: 400 Bad Request Status Code: 401 Unauthorized
Error Code	00, 01, 06,14,35,36,37,38,40, 47, 79, 92, 99, 107,142,143

SelectRowsFromDwTable

URL	LIVE: https://api.relateddigital.com/resta/api/Datawarehouse/SelectRowsFromDwTable ECOMM: https://api.relateddigital.com/reste/api/Datawarehouse/SelectRowsFromDwTable LIVEB: https://api.relateddigital.com/liveb_rest/api/Datawarehouse/SelectRowsFromDwTable LIVEM: https://api.relateddigital.com/restm/api/Datawarehouse/SelectRowsFromDwTable
Http verb	POST
Parameters
Header	Content-Type: application/json Authorization: The ticket given by the system after successfull login
Body	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 Body	Sample: { "DwTableName": "sample string 1", "Key": "sample string 2", "Value": "sample string 3" }
Sample Response	{ "MemberId": "" "Success": false, "Errors": [ { "Code": "", "Message": "" } ], "DetailedMessage": "" "TransactionId": "" }
Succcess Response	Status Code: 200
Http Error Response	Status Code: 400 Bad Request Status Code: 401 Unauthorized
Error Code	00, 01, 06,14,18,19,25,35,36,37,38,40, 47, 79, 92, 99, 107, 117

Parent Topic: RMC REST API