On this Page:
...
InsertUpdateRowInDwTable
URL | LIVE: http://api.relateddigital.com/resta/api/Datawarehouse/InsertUpdateRowInDwTable ECOMM: http://api.relateddigital.com/reste/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, 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. |
Sample Body | { "DwTableName" : "", "Key" : "", "Value" : "", "ForceUpdate" : false, "DemographicData" : [ { "Key" : "", "Value": ""} ], "InsertEmptyValueForNonDemographicColumns": false } |
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: http://api.relateddigital.com/resta/api/Datawarehouse/UploadDataWarehouseFile ECOMM: http://api.relateddigital.com/reste/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: http://api.relateddigital.com/resta/api/Datawarehouse/BulkInsertUpdateRowInDwTable ECOMM: http://api.relateddigital.com/reste/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, 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. |
Sample Body | { "DwTableName" : "pgp_data", "KeyColumn" : "KEY_ID", "MemberList" : [ { "DemographicData": [ {"Key" : "NAME", "Value" : ""} ], "KeyColumnValue" : " " }, { "DemographicData": [ {"Key" : "EMAIL", "Value" : ""} , {"Key" : "COL_INT", "Value" : "22"} ], "KeyColumnValue " : " " } ] } |
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: http://api.relateddigital.com/resta/api/datawarehouse/querymemberdatawarehouse ECOMM: http://api.relateddigital.com/reste/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 | { "KeyColumn" : " ", "Values":["",""], "PageNumber":1, "PageSize":100 |
Sample Response | { |
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: http://api.relateddigital.com/resta/api/datawarehouse/GetFLTableColumns ECOMM: http://api.relateddigital.com/reste/api/datawarehouse/GetFLTableColumns |
---|---|
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 | { } |
Sample Response | { |
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: http://api.relateddigital.com/resta/api/datawarehouse/UpdateDwTableExpireDate ECOMM: http://api.relateddigital.com/reste/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 | { "NewDate":"" } |
Sample Response | { |
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: http://api.relateddigital.com/resta/api/Datawarehouse/SelectRowsFromDwTable ECOMM: http://api.relateddigital.com/reste/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 | { "Success": false, "Errors": [ { "Message": "" "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 |
...