Home > Mobile >  How to merge two api in python by id in python?
How to merge two api in python by id in python?

Time:09-28

I want to create a dictionary with using 2 api. Can you guide me?
I want to create a dictionary with using 2 api. Can you guide me?

url = 'https://test.com/api/v1/'
tags = []
result=[]
    
response = requests.get(url)
results = json.loads(response.text)

for data in results['results']:

    

second API

url = 'https://test.com/api/v1/' data['tags_id']

response = requests.get(url)
results = json.loads(response.text)


for data in results['tags']:
    tags.append(data['title']) 

result of first api

    results: [
            {
              "title": "subject1",
              "tags_id": "86111ae6",
     },
            {
              "title": "subject2",
              "tags_id": "86ae6",
     }]

expected result

    results: [
            {
              "title": "subject1",
              "tags: ['a','b'],
     },
            {
              "title": "subject2",
              "tags": ['c','d','f'],
     }]

second API

  "tags": [
    {
   "title": 'a',
    },
    {
   "title": 'b',
    },
  ]

CodePudding user response:

Since each "title" from the first API has exactly one "tags_id", I think what you want is something like:

url = 'https://test.com/api/v1/'
response = requests.get(url)
results = json.loads(response.text)

output = list()
for d in results['results']:
    response = requests.get(f'https://test.com/api/v1/{d["tags_id"]}/show_tags')
    result = json.loads(response.text)
    output.append({"title": d["title"], 
                   "tags": [t["title"] for t in result["tags"]]})
  • Related