Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Using web source for incremental refresh

I am trying to use a web site which returns json as the source for a table and due to the amount of data am trying to implement incremental refresh.  I am attempting to use the string versions of the...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    You may try this. This doesn't have syntax error. 

    let
strRangeStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd"]),
strRangeEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd"]),
Source = Json.Document(Web.Contents("https://volt0328.attendanceondemand.com/mobile/mssrestba.aew/v1/employees/paydes/daily/detail?hyperQ... Employees&periodSel=custom&from=" & strRangeStart & "&to=" & strRangeEnd, [Timeout=#duration(0,0,30,0)]))
in
Source

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

ppm1's avatar
ppm1
Solution Sage
3 years ago

Your approach should work. But you need to add the  "&" back in. Try this instead.

 

let
strRangeStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd"]),
strRangeEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd"]),
Source = Json.Document(Web.Contents("https://volt0328.attendanceondemand.com/mobile/mssrestba.aew/v1/employees/paydes/daily/detail?hyperQ... Employees&periodSel=custom&from=" & strRangeStart & "&to=" & strRangeEnd, [Timeout=#duration(0,0,30,0)]))"
in
Source

 

Pat