import json import requests import pandas as pd response = requests.get("https://www.receitaws.com.br/v1/cnpj/27865757000102") data = json.loads(response.content.decode(response.encoding)) df = pd.DataFrame([data])