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

Anonymous — Tue, 07 May 2019 13:21:48 GMT

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

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

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