Forum Discussion

jnickell's avatar
jnickell
Helper V
6 years ago
Solved

Issues with using a parameter in web.content url in dataflow

This seems to be something others have struggled with and I've tried a few different ways, but when I attempt to create a function, and pass it as a parameter used in getting a specific web resource ...
Dataflow
Need Help
  • jnickell's avatar
    jnickell
    6 years ago

    After some more digging, I think I found something that works.  Using, RelativePath the function attribute.

    I updated the query to have ReportQueryURL be the full path up to the "ID" value I needed to parameterize.  

     

    ReportResult = Web.Contents(ReportQueryURL,
          [RelativePath=ReportID,
          Headers=ReportHeader]),
        ReportOutput = Csv.Document(ReportResult),

     

    I'm able to save the dataflow, with the function, and my first 'test' of the function is working as well.  

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi jnickell ，

 

So has the issue  been solved now?

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!
jnickell's avatar
jnickell
Helper V
6 years ago

Yes my issue seems to be resolved now.