Versions Compared

Old Version 31

changes.mady.by.user Berk Topaloğlu

Saved on

compared with

New Version Current

changes.mady.by.user Berk Topaloğlu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

On this Page:

Table of Contents

InsertUpdateRowInDwTable 

...

URL

...

On this Page:

Table of Contents


...

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, give Code not equal 00 back and put Already existing member in Messagefunction doesn't update the member.

DemographicData(KeyValue []): This is an 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" : falsetrue,

"DemographicData" :

      [

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

      ],

"InsertEmptyValueForNonDemographicColumns": falsetrue

}

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

...

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, MEMBER_ID or any column the developer wants like Name, Surname as configured by using Euro.Message admin panelThis 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. İf If this value sent in wrong format, its ignored and the main process is not interrupted.

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

Sample Body

{
 
   "DwTableName":"
pgp_data
BulkerTest3",
 
   "KeyColumn":"EMAIL",
   "MemberList":[
      {
            "KeyColumnValue":"
KEY_ID
abdullahdarcin@euromsg.com",
 
            "
MemberList
DemographicData":
 
[
       
               
                {

                               "DemographicData":

                                                                 [     

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

                                 "KeyColumnValue" : " "

                },

                {

                               "DemographicData":

                                                                 [     

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

                                               {
        },
        {
            "KeyColumnValue":"abdullah.darcin@euromsg.com",
            "DemographicData":[
                {
                "Key":"
COL_INT
NAME",
                "Value":"
22
Abdullah"
                }
                                                                
            ]
,

                              "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

...

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

...