none
Related Queries RRS feed

  • Question

  • Hi

    I Have 3 json URL and need to combine them and import in excel with Power Query to extract some information from them (e.g. count of comments)

    FYI: Query 3 depend to query 2 and query 2 depend to query 1

    1-#all projects (out put of this equal to projectid's, a table with 100 row)

    http://ip:port/rest/project/all

    2-#all issues id in a project (projectid from step 1 add to end of URL step 2 , out put of this equal to issueid's, a table with 2000 row)

    http://ip:port/rest/issue/byproject/projectid

    3-#all comments in a issue (issueid from step 2 add to below URL, a table with 3000 row  )
    http://ip:port/rest/issueid/comment

    Thanks,



    • Edited by Indeed_1 Saturday, August 4, 2018 6:16 AM
    Saturday, August 4, 2018 6:13 AM

Answers