Finesse Phone Book Bulk Load

[tmiski]

Is there any way to bulk load Finesse Phone Books?

Thanks, Ted

[James Hawkins]

The Finesse REST API allows you to create and modify phone books.

https://developer.cisco.com/site/finesse/docs/guides/rest-api-dev-guide/

You could write a script in Python or Powershell to use the API to upload phonebook data in CSV format.

[TomLoos1234]

Following the API guide, we're running into an issue:

We want to do an automatic import using powershell of a CSV in an existing phonebook in Finesse.

The response we’re getting is Bad request (400)…

Invoke-WebRequest -Uri https://<FINESSESERVER>/finesse/api/PhoneBook/1/Contacts/csvFileContent -Method post -Credential $cred -InFile test.csv -ContentType "text/CSV"

Invoke-WebRequest : The remote server returned an error: (400) Bad Request.

Anyone knows what we’re doing wrong ?

Thx and kind regards !

[Anthony Holloway]

I don't know PowerShell very well, but it looks like you need to submit a multipart form data, and not text/CSV.

Look at this for an example:

https://stackoverflow.com/questions/36268925/powershell-invoke-restmethod-multipart-form-data

[SuccessfulChap123]

$FileName = ".\pb.csv"

$Password = ConvertTo-SecureString “passwordhere” -AsPlainText -Force

$Cred = New-Object System.Management.Automation.PSCredential (“usernamehere”, $password)

Obviously, this is not very secure but its simply a proof of concept to do whatever you need;

Invoke-WebRequest - uri "https://servername.com:8445/finesse/api/PhoneBook/4/Contacts/csvFileContent" -Method Put -Credential $Cred -InFile $FileName

Download Phone Book - (4 being the ID of the phone book)
https://servername.com:8445/finesse/api/PhoneBook/4/Contacts/csvFileContent

if you post, you upload to the above link thats in the Powershell above. 

List specific details for a phone book - (4 being the ID of the phone book)
https://servername.com:8445/finesse/api/PhoneBook/4/

List contacts for specific phone book - (4 being the ID of the phone book)
https://servername.com:8445/finesse/api/PhoneBook/4/Contacts/

Ref - http://squirrelsuccess.blogspot.com/2019/11/uccx-phone-books-powershell.html 

Cheers