Skip to main content
Product Hacks

Export all users information in your org

  • June 26, 2020
  • 1 reply
  • 398 views
Export all users information in your org
Rica
Pipefy Staff
  • Pipefy Staff
  • 4 replies

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.

Did this topic help you find an answer to your question?

1 reply

khatkechetana
Forum|alt.badge.img

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings