Product Hacks

Export all users information in your org

  • 26 June 2020
  • 1 reply
  • 311 views
Export all users information in your org
Userlevel 5

Have you already asked yourself if there’s an easier way to pull a list of all users from your Pipefy organization? 

 

Well, there’s a thing called GraphQL query that maybe can help you. 

 

GraphQL is a query language for your API, and a server-side runtime for executing queries by using a type system you define for your data. This technology helps you search for information in your organization in a much faster and practical way.

 

Ok, but you are probably asking yourself what should I do?

 

First, you need to access Pipefy’s GraphQL page: https://app.pipefy.com/graphiql , that should pretty much look like this:

 

eTaIs9ndUyMUzphGCje33jCIzzA0Ylw8AdrBzdqLtsdh_2ZxijeUS609B_kyRGoJEOL-htwUpO51TgeWKlRuS82jNLrTuuc8HLL7uZ2fchSYDo6KW3_ljMOWhLmaZFAscA2tLJHR


 

Now you should paste the query below on the left white side of the page:

 

Query:

 

{

 organizations(ids: [Paste here your Org ID]) {

  members {

    user {

      name

      email

    }

  }

}

}

 

It should look like this (example):

 

{

 organizations(ids: [91162]) {

  members {

    user {

      name

      email

    }

  }

}

}

 

After that, press the execute KE3-vr5iFr-bYMoO_TGnqIHBUmNUe_mOk-o0bsDNovQ25nZiztPuUloD5D50Dfa2fmdotCKcboTFjoZbtybgsTVtc7tI6QmIbjkdN22nGc-VrtPqUiJy3IvALvEC4zGOl1BKO642 button on the top left side of your screen.

 

A list of information will appear on the right side of the screen. The language you are seeing is JSON. To convert to a CSV format I recommend using this website: https://json-csv.com/

 

After that, paste it in  the whitebox on your screen and download an excel file with a list of all members inside your Pipefy organization.

 

8sgJBoVXlQT8_yM6AZT7gleYNAXk1fdUjdPMw77VjjICBtsc319QKxbcbZc4SViGIja-Dge4YtpIbpJEiag8xYju4jj0qIhBACDVArYx0S5kjDNm8aaCJkHJsX-m1upVIOPn5jSg

 

There you go! Now you have a list with all users inside your Pipefy organization.


1 reply

Userlevel 4
Badge

How we can convert csv file to Excel file and compare each other and find out the difference?

Reply