cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
grooble Frequent Visitor
Frequent Visitor

get column data for web lookup

I am using a web lookup to get Facebook data in to a table.
Here is the data that I can get out in to a Post table, where each row is a single post:
posts_table.PNG

So this is working well.

 

The next thing I want to do is use the id column from the above table to get the comments for each post.

 

Looking at the Facebook Graph api, there is a way to pull comments for multiple posts in a single "batch" request.

This is what I will do in the following Comments query:

let
    Source = Json.Document(Web.Contents("https://graph.facebook.com/v4.0/comments?ids=4317533336*****_11936468075*****,4317533336*****_11924034843*****&access_token=mytoken"))
in
    Source

The above url will get me two comments into a new table and this is also working ok.

 

What I want to do is take the ids from the Posts table and insert them into the Comments query above, so that the url will look like this:

https://graph.facebook.com/v4.0/comments?ids=id1,id2,...,idn&access_token=mytoken

...where id1, id2 etc are from the [id] column of the Posts table.

How do I accomplish this?

2 REPLIES 2
amitchandak Super Contributor
Super Contributor

Re: get column data for web lookup

I am not sure I got it completely. But please try.

Get the position of ids and *****& and then split string based on *****

Refer

https://docs.microsoft.com/en-us/dax/text-functions-dax

grooble Frequent Visitor
Frequent Visitor

Re: get column data for web lookup

Hi and thanks for your reply.
I guess it boils down to: how do I get all the IDs from the Posts table in the comments Query?

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 398 members 3,548 guests
Please welcome our newest community members: