Forum Discussion

ERIC_A's avatar
ERIC_A
Helper II
4 years ago

API with Python Returns Nothing

Hello I am trying to get a power BI connection to an intranet website to manipulate some data and put it in a table in powerBI.  My python script works fine in Visual studio code but I don't know wh...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

You are printing too much.  Only return the result.

NvanOort's avatar
NvanOort
Frequent Visitor
2 years ago

Thanks for your quick response!

Still no data unfortunately. Only using this part for the result now:

 

print(response.json())

 

Got an error message earlier that Matplotlib and Pandas was not installed. Done that in the meantime and to be sure I just tested the script by addring those libraries as import but that does not help eighter.

 

Sorry, I'am new to Python.

  • ERIC_A's avatar
    ERIC_A
    Helper II
    2 years ago

    Hi,

    I remember the issue was the syntax of filtering. This is what was causing my code to return an empty object. see below:

     

    It turns out that the syntax for empty filters changes from [] to {} and also the syntax for list inside the payload changed from [A="X",B="Y"] to {[A="X",B="Y"]}