Forum Discussion

CEllis's avatar
CEllis
Icon for Resolver I rankResolver I
2 years ago
Solved

CURL

I was woundering if anyone had experience in using Wonde api with dataflows ?      
Need Help
  • CEllis's avatar
    CEllis
    2 years ago

    lbendlin 

     

    Thanks for the direction the problem I had was the authetication method.

     mwoollen soloution below worked in the dataflow.

     

    Not sure why but I had to use the token in the username and have a blank password for the refresh schedule to work which I though was odd.

     

    let
  Username = "[your username]",
  Password = "[your password or TOKEN]",
  UserPass = Username & ":" & Password,
  Bytes = Text.ToBinary(UserPass),
  Base64_UserPass = Binary.ToText(Bytes, BinaryEncoding.Base64),
  TargetURL = "[target URL]",
//TargetURL = "https://companyxyz.atlassian.net/rest/api/latest/search",
  Source = Json.Document(Web.Contents(TargetURL,
  [
     Headers = [
      #"Authorization" = "Basic " & Base64_UserPass, 
      #"Content-Type" = "application/json"
     ]
  ]
  ))
in
  Source

     

    Many thanks

     

    Chris

     

CEllis's avatar
CEllis
Icon for Resolver I rankResolver I
2 years ago

In this example Wonde Integration with Power BI using the API | Power BI for Schools it shows a function called 'fGetStudents' and a query to call the function. This works and brings the records back.

 

However, when editing the data flow the connection has to be set to 'Anonymouse' for the code to work.

 

But when refreshing the dataflow it says 'Error: Credentials not found for data source'

 

 

  • CEllis's avatar
    CEllis
    Icon for Resolver I rankResolver I
    2 years ago

    Gen1

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Make it work on the desktop and then see if you can transplant it to the dataflow.

  • CEllis's avatar
    CEllis
    Icon for Resolver I rankResolver I
    2 years ago

    lbendlin 

     

    Thanks for the direction the problem I had was the authetication method.

     mwoollen soloution below worked in the dataflow.

     

    Not sure why but I had to use the token in the username and have a blank password for the refresh schedule to work which I though was odd.

     

    let
  Username = "[your username]",
  Password = "[your password or TOKEN]",
  UserPass = Username & ":" & Password,
  Bytes = Text.ToBinary(UserPass),
  Base64_UserPass = Binary.ToText(Bytes, BinaryEncoding.Base64),
  TargetURL = "[target URL]",
//TargetURL = "https://companyxyz.atlassian.net/rest/api/latest/search",
  Source = Json.Document(Web.Contents(TargetURL,
  [
     Headers = [
      #"Authorization" = "Basic " & Base64_UserPass, 
      #"Content-Type" = "application/json"
     ]
  ]
  ))
in
  Source

     

    Many thanks

     

    Chris