Import Full Accounts from SFTP **Dataflows - UID issue**

[mstachel]

Hello guys,

we are currently trying to import Full Accounts from a SFTP into SAP Customer Data Cloud.

We have created a Dataflows using the default importing function for the import of FullAcounts:

For the importing structure we have create a JSON file on the SFTP server with the following structure:

{
"profile": {
"email": "Jo@mailinator.com",
"firstName": "Santa",
"lastName": "Claus",
"gender": "m",
"city": "NorthPole"
}
}

The dataflow is completed with an error and a log file is written to the SFTP server path containg this information:

[
{"profile":{"email":"Jo@mailinator.com","firstName":"Santa","lastName":"Claus","gender":"m","city":"NorthPole"},"_errorDetails":{"errorCode":400002,"errorMessage":"UID: null. Details: Uid must be provided"}}
]

>>> Why do we need to provide an UID when we want to create a new Account in SAP CDC? Is there some kind of placeholder which we need to define in the JSON structure so that SAP CDC does generate a new UID? We do not understand why we need to provide a UID in the importing file. Or do we use a wrong JSON file format? Can you please give us a hint what we are doing wrong?

Thanks for your help!

Cheers,

Marco

[SonalSaurabh · Accepted solution]

Hi Marco,

The import account in dataflow , uses the accounts.importfullaccount rest api in backend to create the accounts. For this rest api , UID is a mandatory parameter hence the error occurred. You can use below two options

1. pass the UID from SFTP

2. use records.evaluate in dataflow to generate a dynamic UID

Once you have defined the process for UID the accounts would be created successfully.

Please refer to the link for more information on the accounts.importfullaccount rest api

https://help.sap.com/viewer/8b8d6fffe113457094a17701f63e3d6a/GIGYA/en-US/41365a5370b21014bbc5a10ce40...

Please refer to the below link to generate dynamic UID, under the Tips and Tricks topic:

https://help.sap.com/viewer/8b8d6fffe113457094a17701f63e3d6a/GIGYA/en-US/417dd0d470b21014bbc5a10ce40...

Hopefully this should help in resolving the issue.

Thanks,

Sonal Saurabh