Create JSON file using Python Script and reading it from the script

[Anonymous]

I am developing an API integration to use it on Power BI. The problem is that I have done this integration in a Python Script.

Here is the code:

import requests
import json

app_key = "1560731700"#EXAMPLE APP KEY
app_secret = "226dcf372489bb45ceede61bfd98f0f1" #EXAMPLE APP SECRET

response = requests.get('https://app.omie.com.br/api/v1/financas/contapagar/?JSON={"call":"ListarContasPagar","app_key":"%s","app_secret":"%s","param":[{"pagina":1,"registros_por_pagina":100,"apenas_importado_api":"N"}]}'%(app_key,app_secret)).status_code
if response != 200:
    print("Invalid Parameters")
else:
    response = requests.get('https://app.omie.com.br/api/v1/financas/contapagar/?JSON={"call":"ListarContasPagar","app_key":"%s","app_secret":"%s","param":[{"pagina":1,"registros_por_pagina":100,"apenas_importado_api":"N"}]}'%(app_key,app_secret)).json()
    total = response["total_de_paginas"]
    contas_pagar = response["conta_pagar_cadastro"]
    for i in range(1, total + 1):
        response = requests.get('https://app.omie.com.br/api/v1/financas/contapagar/?JSON={"call":"ListarContasPagar","app_key":"%s","app_secret":"%s","param":[{"pagina":%s,"registros_por_pagina":100,"apenas_importado_api":"N"}]}'%(app_key,app_secret,i)).json()
        
        with open("teste.json", "w") as teste: #I created a file called teste.json to dump the initial json.
            json.dump(contas_pagar,teste,indent=4)
            
        
        with open("teste.json", "r") as teste: #then I recall it, with readlines
            lines = teste.readlines()
        
        if i == 1:
            mode = "w"
        else:
            mode = "a"
            
        if i != total:
            with open("resultado.json", mode) as teste: #and write it down on another one!
                for b in range(len(lines)-1):
                    if b == 0 and mode == "a":
                        pass
                    elif b == len(lines) - 2:
                        teste.write(str(lines[b]).rstrip("\n") + ",")
                    else:
                        teste.write(lines[b])
                
        if i == total:
            with open("resultado.json", mode) as teste:
                for b in range(len(lines)-1):
                    if b == 0 and mode == "a":
                        pass
                    else:
                        teste.write(lines[b])
                teste.write("]")

        print("Page completed: %s" %i)

The problem is that my code generates 2 new json files while executing and I can't use dataset=teste on the code, because Power BI doesn't recognize it. 

Is there anyway I can read the resultado.json file on Power BI generated on Python Script?

PS: I have to run this code on PBI, to keep the flow automatically