Reply
Highlighted

Problems starting CSV Import via WAPI

vjockheck
Techie
Posts: 8
1219     0

Hi @all,

 

I´m trying to start a CSV import via the WAPI. Unfortunately I´m getting the following error message

 

"Error": "AdmConDataError: None (IBDataError: IB.Data:CSV Import file is not valid. First line of the file must be either a valid version number or a valid header line.

This is my import file. It is encoded in us-ascii which should be correct.

 

header-fixedaddress,IMPORT-ACTION,ip_address*,mac_address,match_option,ms_server
fixedaddress,I,10.54.0.3,12:34:56:78:90:12,MAC_ADDRESS,
fixedaddress,I,10.54.0.4,22:34:56:78:90:12,MAC_ADDRESS,

 

Importing this file via the WebGui works perfect.


Here are my commands to start the upload

 

curl -k -u XXX:XXX -H content-type:application/json -X POST 'https://1.2.3.4/wapi/v2.7/fileop?_function=uploadinit


curl -k -u XXX:XXX -H content-type:multipart-formdata https://1.2.3.4/http_direct_file_io/req_id-UPLOAD-1056/import_file -F file=@test8-UTF.csv


curl -k -u XXX:XXX -H content-type:application/json -X POST 'https://1.2.3.4/wapi/v2.7/fileop?_function=csv_import' -d '{"action":"START","on_error":"CONTINUE","update_method":"OVERRIDE","separator":"COMMA","operation":"CUSTOM","token":<TOKEN>"}'

 

 

I shortend the last command because the token is less relevant.
Do you have any idea why I´m getting this error message?

 

kind regards
Volker

Re: Problems starting CSV Import via WAPI

Adviser
Posts: 93
1220     0

The CSV exampe is formatted as a custom import type.  But you're specifying an override import.  The API guide doesn't offer CUSTOM as an import type for API.

 

You could try changing the import type from OVERRIDE to CUSTOM but that may not actually work.

 

... "update_method":"OVERRIDE" ...

 

Probably you need to change the CSV file to be a traditional import type, by removing the IMPORT-ACTION column.

Re: Problems starting CSV Import via WAPI

vjockheck
Techie
Posts: 8
1220     0

Thanks for your response.

You are right. Unfortunately only "Merge" and "Override" are supported values for "update_method". So I removed the column "IMPORT-ACTION". But I still get the same error message.

 

curl -k -u XXX:XXX -H 'content-type:application/json' -X POST "https://1.2.3.4/wapi/v2.7/fileop?_function=csv_import" -d '{"action":"START","on_error":"CONTINUE","update_method":"OVERRIDE","separator":"COMMA","operation":"INSERT","token":"'"$TOKEN"'"}'

 

This is my new import file:

 

header-fixedaddress,ip_address*,mac_address,match_option,ms_server
fixedaddress,10.54.0.3,12:34:56:78:90:12,MAC_ADDRESS,
fixedaddress,10.54.0.4,22:34:56:78:90:12,MAC_ADDRESS,

 

Any other idea?

 

 

Showing results for 
Search instead for 
Do you mean 

Recommended for You