Forum Discussion

data_team_afri's avatar
data_team_afri
Frequent Visitor
7 years ago

Error: Split json web contents with api token

Hello, This is to request help to split a json weblink I have an json file retreived from an api web link: Before Change:  = Json.Document(Web.Contents(" https://api.funnel.io/api/account/v1/-...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi data_team_afri,

 

Maybe you can mofidy the query like this and check if this can work.

= Json.Document(Web.Contents("https://api.funnel.io/api/",
[
RelativePath="account/v1/-account_id-/project/project_id"
Query=
[
group_by="campaign_day",
start_day=Date.FromText("2017-01-01"),
end_day=Date.FromText("2050-12-31"),
fields="common-cost",
apikey="12345_example",
]
]
))

Regards,

Jimmy Tao