SD-WAN Fileupload API Error

[prjoseph]

I am trying to upload a edge list serial no file to the vManage server using the dataservice/system/device/fileupload  endpoint.

vManage Server platform version is 20.6.3.1

Below is the curl command used

curl --insecure -v -F "file=@serial.csv" -F "validity=valid" -F "upload=true" -b"JSESSIONID=xxxxxxxxxxx" -H "X-XSRF-TOKEN:XXXXXX" https://X.x.x.x/dataservice/system/device/fileupload

I am getting below response. The response is not giving any details

{"error":{"type":"error","message":"File upload failed.","details":"Unknown error","code":"VELIST0001"}}

Below is the contents of serial.csv 

FDO2133ABCD,C8200-1N-4T,01CED200,

Any idea why this failing ?

Anyone has sample on how we can upload to the vManage server the edge list ?

[bigevilbeard]

Sadly the errors you get here are quite generic, which does not help when troubleshooting, the only thing i see is the trailing comma. From what i recall the CSV file has to adhere strictly to the format expected by vManage, should be no extra spaces, the delimiter should be a comma (","), and the file should not contain a header row.

curl --insecure -v \
  -F "file=@serial.csv" \
  -F "validity=valid" \
  -F "upload=true" \
  -b "JSESSIONID=xxxxxxxxxxx" \
  -H "X-XSRF-TOKEN:XXXXXX" \
  https://X.x.x.x/dataservice/system/device/vedge/upload

 I did find this old threat, seems my memory isnt that bad! https://community.cisco.com/t5/controllers/upload-vedge-file-to-vmanage-validity-string-not-found-in/td-p/4951939

Hope this helps.