Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

Convert JSON output of List Users command

Udzielono odpowiedzi
Zamów wersję demonstracyjną

Hi All,

I am trying to export the list of Workiva users in a chain and then upload to a Workiva table. I am able to get the list of users using the "List Users" command in the chain. But then I'm not able to convert the JSON output using any of the JSON commands or the Handlebars tool. All of the tools I use say they're successful, but there's no actual output of data. The first thing I tried was just getting the emails out of the array with even that isn't working. Can anyone advise? Here are some pictures of the chain and the commands that I've tried. 

0

Komentarze

Komentarze: 4

Data Głosy
  • Wade Hays

    Your Array to CSV command is very close. The user information is nested in an object "attributes" so your JSON path would be ".attributes.email"

     

    Regards, Wade
    --
    Wade Hays - Tower Turn

    0
  • Stephenie Kern

    Thank you Wade! That worked. 

    0
  • Anurag Shukla

    Hi Wade,

    I am also trying the same thing but i also want to extract list of all the workspace and workspace roles associated to that user, how can i do that?

     

    Ragards,

    Anurag

    0
  • Jeff Hickey

    Hi Anurag Shukla,

    You can get workspace and workspace roles in attributes.workspaceMemberships. For more information and to see an example response of all information available, please reference https://developers.workiva.com/admin-v1/admin-getorgreportusers/#example-responses.

    0

Zaloguj się, aby dodać komentarz.