[SalesForce] Data encryption in exact target

You would want to use dataevents by addingg rowsets.

Here is a sample call -

POST https://www.exacttargetapis.com/hub/v1/dataevents/key:DataExtensionExternalKey/rowset

Add the header:

Authorization: Bearer gd2324hruukedkremtwqhae9

and the payload:

[
    {
        "keys":{
                "Email": "someone@exacttarget.com"
                },
        "values":{
                "LastLogin": "2013-05-23T14:32:00Z",
                "IsActive": true,
                "FirstName": "John",
                "FollowerCount": 2,
                "LastName": "Smith"
                }
    },
    {
        "keys": {
                "Email": "someone2@exacttarget.com"
                },
        "values":{
                "LastLogin": "2013-05-23T14:32:00Z",
                "IsActive": true,
                "FirstName": "Jane",
                "FollowerCount": 2,
                "LastName": "Smith"
                }
    }
]

This may help. It is how we get data into Data Extensions from an FTP site. So long as all your logic is done on your side to generate a CSV, this would work. The steps would be (from within your ET account) 1. Create a File Transfer activity to bring the file into our data warehouse. 2. Create an Import Activity to import said file into your data extension of choice. 3. Create an Automation from with AutomationStudio to run 1&2 sequentially, either at set times or by an API trigger.

See http://help.exacttarget.com/en/documentation/exacttarget/interactions/activities/file_transfer_activity/

And

http://help.exacttarget.com/en/documentation/exacttarget/interactions/activities/import_activity/

Hope this helps... Good luck!