Forum Discussion

cesarsan7's avatar
cesarsan7
Frequent Visitor
2 years ago
Solved

Refresh/Launch a DataFlowGen2 from the pipeline using Dynamic content

Hello,

I'm using Microsoft Fabric and I'm trying to refresh/launch a DataFlowGen2 from the pipeline using Dynamic content, but I'm getting an error. However, when I set the Dataflow name in hard code, the pipeline ran fine.

 

Error 

Please help.

Cesar Sanchez

pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Cesar,

    That param is looking for the Object ID, not the text name.

    Is there a function to lookup the object ID that you can replace your @variables function with?

  • Anonymous's avatar
    Anonymous
    2 years ago

    If you want to test this, export a Dataflow as .json, the Dataflow ID is the second parameter in the metadata (header)

    then pass this ID as the parameter.

    If you can find a function to look this up dynamically. I can see code in the forum but it's a bit untidy.

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Cesar,

    That param is looking for the Object ID, not the text name.

    Is there a function to lookup the object ID that you can replace your @variables function with?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi cesarsan7 
      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
      Thanks

    • cesarsan7's avatar
      cesarsan7
      Frequent Visitor
      2 years ago

      Hi richardrann,

       

      Thanks for your reply.


      I am using the dataflowId I got from the JSON file and then using this value to start DataFlow Gen2 from Foreach.

       

      Ideally, it could be that the ID could be obtained from the name. Do you know if there is a function that does this?

       

      Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    If you want to test this, export a Dataflow as .json, the Dataflow ID is the second parameter in the metadata (header)

    then pass this ID as the parameter.

    If you can find a function to look this up dynamically. I can see code in the forum but it's a bit untidy.

  • NandanHegde's avatar
    NandanHegde
    Super User
    2 years ago

    Hey,

    Not sure but I am not getting any parameterization option and allowing only from drop down :

     

    • cesarsan7's avatar
      cesarsan7
      Frequent Visitor
      2 years ago

      Hi NandanHegde,

       

      The last one option allows you to use dynamic content 

      Thanks.

       

  • DiegoPLAB's avatar
    DiegoPLAB
    Advocate I
    2 years ago

    Hi everybody,

    I understand that using Object ID the problem get solved.

    But if you are developing a metadata-driven pipeline, this is not the best solution. Anyhow, getting the Object ID from browser URL or from exported JSON is not very practical. Also, if you remove and recreate the dataflow, you have to get the new Object ID and update it in your metadata.

     

    The possibility of using Object Name in dynamic content would be a helpful feature.