Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Web connection pulls all data but every record is nested rather than placed in a flat table

When calling the Pipedrive API using a Web connection, I get nested results in the Query Editor rather than a table of data. For example, I receive the following headers; data, additional_data, and r...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks ImkeF, for the suggestion.

     

    Just to recap the solution to this problem:

    Problem: 

    Web connection (URL) to Pipedrive pulls all requested data into a nest table so data cannot be seen unless individually selected.

     

    Solution: 

    Use the Web connection and once the data is received, use the Query Editor to 'convert to table' which will give you a table but each record is still nested.  Click on the icon in one of the column headers and it should convert all 'records' to their actual values.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the suggestion.  I tried that but it still has the records embedded.  I'll take a look at the link you provided to see if it has something I can use.  

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks ImkeF, for the suggestion.

 

Just to recap the solution to this problem:

Problem: 

Web connection (URL) to Pipedrive pulls all requested data into a nest table so data cannot be seen unless individually selected.

 

Solution: 

Use the Web connection and once the data is received, use the Query Editor to 'convert to table' which will give you a table but each record is still nested.  Click on the icon in one of the column headers and it should convert all 'records' to their actual values.