This documentation is for frevvo v10.1. Not for you? Earlier documentation is available too.

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

How do I batch upload users from the API?

The format of the users csv file is the same as that used through the UI CSV Upload of Users and Roles feature.

Users csv upload through HTTP

The users csv upload is available directly through HTTP. One way to do this is using cURL, but other ways are possible. An http change request (post/put/delete) requires a token. This includes operations such as login and upload users by CSV performed through the frevvo Cloud API. Customers using the Cloud API should update their API calls to provide tokens and/or use the new API. 

Here are the steps:

  1. Upload token.

    export CSRF=$(curl -sIL -X GET http://localhost:8080/frevvo/web/no-op -c cookies | grep  "_csrf" | cut -d" " -f2 | tr -d '\n\r')

  2. Log in.

    curl -k http://localhost:8080/frevvo/web/admin/login -d username=admin@tenant -d password=admin_password -d lAction=Login -d _csrf=$CSRF -X POST  -b cookies -H Content-Type:application/x-www-form-urlencoded

  3. Replace host, port, username and password above as correct for your implementation. For  online, host=app.frevvo.com and the port is optional. Change http to https.

    If your tenant is on the frevvo cloud server, and you see the error "Couldn't open file "users.csv", perform one of the following actions:

    • Update the trusted certificate authorities present on your client machine
    • Disable the certificate check with the cURL -k option:
    curl http://host:port/frevvo/web/login -d username=admin@tenant -d password=admin_password -d lAction=Login -d _csrf=$CSRF -X POST  -b cookies -H Content-Type:application/x-www-form-urlencoded -k

  4. Upload the users csv file:  

    curl http://localhost:8080/frevvo/web/tn/tenantid/allUsers?_csrf=$CSRF -F notificationEmailAddress=some_email_address -F usersFile=@users-t1-100.csv  -X POST  -b cookies -H Content-Type:multipart/form-data
  5. Replace host, port, tenant.id, some_email_address and users_file.csv above as correct for your implementation. If users_file.csv is not in the current directory, adjust the path accordingly. For frevvoonline, host=app.frevvo.com and port is optional. Change http to https.
  6.  Check the some_email_address for incoming email with the results of the load.

  7. (Optional) Get the user csv back from frevvo. It will have all users, including all that were loaded:

    curl http://host:port/frevvo/web/tn/tenant.id/allUsers  -X GET  -b cookies

    For frevvoonline, host=app.frevvo.com and port is optional. Change http to https and add the -k option

    curl http://host:port/frevvo/web/tn/tenant.id/allUsers  -X GET  -b cookies -k
  8. The response will be the users csv data.
  • No labels