Blog

User Data Table (UDT) is the collection of contacts with additional user attributes (Eg: Email, Address) that can be then used to personalize and target campaigns. The contact details added to a user data table do not alter or impact the contact details that are available on the CEE panel contact master.

The following activities associated with UDTs can be performed using the API listed in this section:

  • Create: to create a user data table (UDT)
  • Upload: to upload user contacts to a created user data table (UDT)

Create UDT API

URL Schema:
US: http://api.netcoresmartech.com/apiv2
IN: http://apiin.netcoresmartech.com/apiv2
EU: https://jsonapi.eu-north-1.eu.netcoresmartech.com/apiv2

Method: POST
Header:

KeyValue
Content-Typeapplication/x-www-form-urlencoded

Parameters:

ParameterDescriptionData TypeRequiredParameter Type
typeIt represents the module or group the API belongs to. For example, if the API 's functionality is related to Contacts, type is 'contact'.

Value here: lists
stringYesQuery Parameter
activityActivity refers to the action that is being performed through the API, that is, add, delete, update, and so on.

Value here: add
stringYesQuery Parameter
apikeyYou can login to your Netcore panel > Go to Profile settings > User Profile > You can find API key here.stringYesQuery Parameter
listnameThe name of the list that you are creating.StringYesQuery Parameter
listtypeThis refers to the type of list you want to create.

Value here: udt
StringYesQuery Parameter
udt_attrHere you need to pass attributes present in the UDT CSV in json format as given below. UDT must have atleast one attributes besides the primary key

Sample:
[{"name":"EMAIL","type":"varchar"},{"name":"NAME","type":"varchar"},{"name":"DISCOUNT","type":"varchar"}]
JsonYesQuery Parameter

Request:
Request URL:

http://api.netcoresmartech.com/apiv2?type=lists&activity=add&apikey=<api_key>&listname=<list_name>&listtype=udt&udt_attr=

Request sample for reference:

http://api.netcoresmartech.com/apiv2?type=lists&activity=add&apikey=xxxxxxxxxx&listname=APN_offer_campaign_221004&listtype=udt&udt_attr=[{"name":"EMAIL","type":"varchar"},{"name":"NAME","type":"varchar"},{"name":"DISCOUNT","type":"varchar"}]

Response: 200 OK

{
    "status": "success",
    "details": "udt added successfully",
    "id": xx
}

Upload bulk contacts to UDT API

URL Schema:
US: http://api.netcoresmartech.com/apiv2
IN: http://apiin.netcoresmartech.com/apiv2
EU: http://goapiv3.eu-north-1.eu.netcoresmartech.com/apiv2

Method: POST
Header:

KeyValue
Content-Typeapplication/x-www-form-urlencoded

Parameters:

ParameterDescriptionData TypeRequiredParameter Type
udtidudtid refers to the id of the UDT (user data table) where you want to upload contacts in bulk via CSV.stringYesQuery Parameter
apikeyYou can login to your Netcore panel > Go to Profile settings > User Profile > You can find API key here.stringYesQuery Parameter
typeIt represents the module or group the API belongs to. For example, if the API 's functionality is related to Contacts, type is 'contact'.

Value here: contact
StringYesQuery Parameter
activityActivity refers to the action that is being performed through the API.

Value here: bulkupload
StringYesQuery Parameter
pathHere you need to provide URL path for the CSV file that you want to upload to a specified UDT ID. Please ensure this CSV file is directly downloadable on this provided path and should end with .csv extension

E.g. https://www.mydomain.com/APN_offer_campaign_221004.csv
StringYesQuery Parameter
notifyemailHere you can provide email id where you will be notified about the status of file upload to the specified UDTStringOptionalQuery Parameter
callbackHere you can provide URL to receive call back on successful upload of file to the specified UDTStringOptionalQuery Parameter

Request:
Request URL:

http://api.netcoresmartech.com/apiv2?udtid=<udtid>&apikey=<api_key>&type=contact&activity=bulkupload&path=<>&notifyemail=<comma seperated emails>&callback=<callback URL>

*Request sample for reference:

http://api.netcoresmartech.com/apiv2?udtid=767&apikey=xxxxxxxxxxx&type=contact&activity=bulkupload&path=https://www.mydomain.com/APN_offer_campaign_221004.csv&callback=https://mydomain.com&[email protected]

Response: 200 OK

{
    "requestid": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    "result": "Success"
}