nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Upload DPSK file via API met error

is_trouser

It shows like below:

{

"message": "DPSK upload file fail, an unexpected error occurred.",

"errorCode": 0,

"errorType": "Internal server error"

}

The DPSK file is the one I exported from web console. I can import it to Zone on the web console. I don't know why it didn't work via API?

Find more posts tagged with

Accepted answers

Parik_MN

Hello @is_trouser,

Follow the steps mentioned below in the screen shot, this is an example of uploading CSV using POSTMAN:

Use the following URL to POST: https://<vSZ_IP>:8443/wsg/api/public/v11_0/rkszones/<Zone_ID>/wlans/<WLAN_ID>/dpsk/upload

1. Navigate and click on BODY tab.

2. Choose option "form-data".

3. Under Key Column, click on file drop down menu.

4. Choose option "file" from drop down menu.

5. Under Value column, click on "select-files" and choose the CSV file.

6. Under Key Column, type in "file" as a Key Value.

7. Hit send, if all the CSV data are valid, vSZ should accept the file and create DPSKs.

Regards,

Parik

All comments

Parik_MN

Hello @is_trouser,

Follow the steps mentioned below in the screen shot, this is an example of uploading CSV using POSTMAN:

Use the following URL to POST: https://<vSZ_IP>:8443/wsg/api/public/v11_0/rkszones/<Zone_ID>/wlans/<WLAN_ID>/dpsk/upload

1. Navigate and click on BODY tab.

2. Choose option "form-data".

3. Under Key Column, click on file drop down menu.

4. Choose option "file" from drop down menu.

5. Under Value column, click on "select-files" and choose the CSV file.

6. Under Key Column, type in "file" as a Key Value.

7. Hit send, if all the CSV data are valid, vSZ should accept the file and create DPSKs.

Regards,

Parik

is_trouser

Hi @Parik_MN

You are right, I missed the 6th step before. Now it works well in Postman.

But actually I want to run it in PowerShell. I have no idea about it. I have never uploaded file via PowerShell. Could you provide a script sample to me? Thanks a lot!

Parik_MN

Hello @is_trouser,

Sorry to say this, we are not PowerShell experts. From API logic perspective, I would suggest to use content-type as mentioned below in PowerShell and the DPSK CSV file URL should be used to upload the file.

Any assistance from Ruckus end? Please feel free to chime in.

Content-Type: multipart/form-data

Regards,

Parik

is_trouser

Hi @Parik_MN I found the solution and test it successfully. Hopefully, it can help other people who has the same issue.

################# Base Info #################
$UrlBase = "https://ac.contoso.com:8443/wsg/api/public";
$apiVer = "v9_1"
$Zone_Id_1 = "69e07745-bac7-4e24-9500-3902960e9700"
$Wlan_Id_1_Office = "45"

################# Create Login Session #################
#Login and transfer Cookie
$Body = [pscustomobject]@{
username = "DPSK_Mgmt"
password = "XXXXXXXXX"
timeZoneUtcOffset = "+08:00"
}
$json = $Body | ConvertTo-Json
$session = Invoke-WebRequest -Uri $UrlBase/$apiVer/session -Method Post -Body $json -ContentType 'application/json' -SessionVariable websession

$stringCookie = [string]$session.Headers["Set-Cookie"]
$cookie = $stringCookie.substring(0,($stringCookie.length - 21))

$headers = @{}
$headers.Add("Cookie",$cookie)

################# Upload DPSK File #################
$FilePath = 'C:/Users/is_trouser/Downloads/batch_dpsk_sample.csv'

$FileName = Split-Path $FilePath -leaf -resolve

$FileBytes = [System.IO.File]::ReadAllBytes($FilePath)
$FileEnc = [System.Text.Encoding]::GetEncoding('UTF-8').GetString($FileBytes)
$boundary = [System.Guid]::NewGuid().ToString()
$LF = "`r`n"

$bodyLines = (
"--$boundary",
"Content-Disposition: form-data; name=`"file`"; filename=`"$FileName`"",
"Content-Type: application/octet-stream$LF",
$FileEnc,
"--$boundary--$LF"
) -join $LF

Invoke-RestMethod -Uri $UrlBase/$apiVer/rkszones/$Zone_Id_1/wlans/$Wlan_Id_1_Office/dpsk/upload -Method POST -Headers $headers -ContentType "multipart/form-data; boundary=`"$boundary`"" -Body $bodyLines -WebSession $websession

################# Remove Login Session #################
Invoke-WebRequest -Uri $UrlBase/$apiVer/session -Method DELETE -ContentType 'application/json'

Notice: CSV file can NOT include any other attributes which is more than sample file and attribute value can NOT be enclosed in quotation marks, otherwise the import will fail with status code 422