Upload dataset API

[afauquem]

Hello,

I am trying to refresh dataset values via API using uploadDatasetCSV.

however I am fancing an issue. The request failed with this error : “Attribute column and csv header must be same”. 
The values have same number of column.

I’ve seen on the forum that the problem was known and need to be fixed : https://forums.saviynt.com/t5/identity-governance/upload-csv-to-dataset-table-via-api-not-working/m-...

I’m using version 24.1.

Is there a higher version where the problem has been fixed?

thank you,

[rushikeshvartak · Accepted solution]

This is working in v24.4

[robcivitello]

Is it possible this is broken again?  I get the same result as the original poster in v 24.5.4

CSV Fields:

cmdb_ci_service_auto_number

cmdb_ci_service_auto_name

cmdb_ci_service_auto_environment

cmdb_ci_service_auto_u_disaster_recovery_tier

cmdb_ci_service_auto_service_status

owner_email

support_group

change_control_group

Dataset Fields:

Result:

[rushikeshvartak]

• Remove content type = Auto

[robcivitello]

It can't be removed, it's a default value in postman, but it doesn't actually show up in the submitted code.  For example here's the curl (with url and token removed)

curl --location --request POST '---removed---/ECM/api/v5/uploadDatasetCSV' \

--header 'Authorization: Bearer ---removed---' \

--form 'datasetname="CMDB_APPLICATION_SERVICES"' \

--form 'datasetValuefile=@"cmdbapps.csv"'

[rushikeshvartak]

Share logs post calling API

[robcivitello]

attached log (url removed)

[rushikeshvartak]

Looking for saviynt logs not postman

[robcivitello]

Logs attached -- also i can see that the file IS actually being uploaded but the dataset isn't being updated. See screenshot of test file that is showing up in saviynt after the API is executed.

[rushikeshvartak]

Logs does not provide proper details