Forum Discussion

msellner_1025's avatar
msellner_1025
Helper I
3 years ago
Solved

Use Result of Query 1 in Query 2

Hello!     I have a query that returns a random file name that I need in order to download a csv formatted reported. Below is the power query that I have set up – it returns the file name as expect...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    Hi msellner_1025,

     

    According to the format of what you say works the line should look like:

     ""fileName"":""" & Expensify_PullDataRequest & """

    Otherwise you either missing the "" ( ""fileName"":Expensify_PullDataRequest) or send Expensify_PullDataRequest as value instead of  is_reconciliation_2816079167651847981.csv.

     

    Cheers,

    John

BA_Pete's avatar
BA_Pete
Super User
3 years ago

 

It may be because you surrounded it with curly braces ( { } ). Try using it just as ""fileName"":"csvFile"

 

Pete

msellner_1025's avatar
msellner_1025
Helper I
3 years ago

BA_Pete 

That was my initial thought, but when I try that, I get the following error.

 

Mikail

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

     

    Does it work just as ""fileName"":csvFile ?

    Sorry, I'm not great with API syntax so not sure what the valid options are.

     

    If that doesn't work, can you send a screenshot of the Expensify_PullDataRequest query result please? It may be an issue with how this is being output.

     

    Pete

    • msellner_1025's avatar
      msellner_1025
      Helper I
      3 years ago

      BA_Pete,

      I tried ""fileName"":csvFile and it returned the same error message. Below is the result of the Expensify_PullDataRequest query.

       

      If I copy and paste this value into query 2 like ""fileName"":""is_reconciliation_2816079167651847981.csv"", it works great. I'm just not sure how to format this as a variable in power query.

      Mikail

      • BA_Pete's avatar
        BA_Pete
        Super User
        3 years ago

         

        Hmm, ok, that seems fine. This should be working ğŸ¤”

        What if you skip the variable declaration and just go straight for ""fileName"":Expensify_PullDataRequest (and other variations of "E_PDR", ""E_PDR"" etc.)?

         

        Pete