Blog Post

Power BI Community Blog
2 MIN READ

How to use JavaScript inside power query for data extraction- Part1

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
5 years ago
TLDR- javascript syntax can be executed inside pqwry through web.page   I recently found out that JavaScript syntax can be run inside Power query for data extraction/wrangling. The way to achieve t...
Published 5 years ago
Version 1.0
Data Wrangling
how to
Power Query
tips & tricks
smpa01's avatar
Icon for Community Champion rankCommunity Champion
Joined March 27, 2017
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower Participant
3 years ago

I have the following Java script following the Jira documentation. 

HttpResponse<JsonNode> response = Unirest.get("https://mediagenix.atlassian.net/rest/api/3/project")
.basicAuth("[email protected]", "LNoi5zTdSjoH28qMJYkc0892")
.header("Accept", "application/json")
.asJson();

System.out.println(response.getBody());

 

How can I convert it into a power query? Thanks!