Python Version For Your Challenge Update!!!

#library for calling GET Requests
import urllib.request
#library for mapping JSON Requests
import json
#library for hadling postgreSQl
import psycopg2


#this is the main function
def main():
    #define the Url here in your case utakuwa na three urls
    #run this url through Postman like how i taught you and see the JSON view for you to understand
    urlData1 = "https://redirect.viglink.com/?format=go&jsonp=vglnk_157494196953111&key=949efb41171ac6ec1bf7f206d57e90b8&libId=k3iaga3z01021u9s000DAauhujszi&loc=https%3A%2F%2Fwww.r-bloggers.com%2Fopen-trade-statistics%2F&v=1&type=U&out=https%3A%2F%2Fapi.tradestatistics.io%2Fcountries&ref=https%3A%2F%2Fwww.google.com%2F&title=Open%20Trade%20Statistics%20%7C%20R-bloggers&txt=https%3A%2F%2Fapi.tradestatistics.io%2Fcountries"
    countryCode="ken"
    year="2016"
    urlData2 = "https://api.tradestatistics.io/yrpc?y="+year+"&r=chl&p="+countryCode+""
    urlData3 = "https://api.tradestatistics.io/products"

    version1="country"
    version2="products"
    version3="trade"

    if(getResponseAndStoreOnDatabase1(urlData1,version1) == True):
        print("Version one is Complete")
    elif(getResponseAndStoreOnDatabase2(urlData2,version2) == True):
        print("Version two is complete")
    else:
        getResponseAndStoreOnDatabase2(urlData3,version3)
        print("Version three is complete")

def getResponseAndStoreOnDatabase1(urlData,version):
    #call the getResponse function passing urlData parameter the function iko chini ya this function
    jsonData = getResponse(urlData)
    if(jsonData is not ''):
        conectToPostGres(jsonData,version)
        return True

def getResponseAndStoreOnDatabase2(urlData,version):
    #call the getResponse function passing urlData parameter the function iko chini ya this function
    jsonData = getResponse(urlData)
    if(jsonData is not ''):
        conectToPostGres(jsonData,version)
        return True

def getResponseAndStoreOnDatabase3(urlData,version):
    #call the getResponse function passing urlData parameter the function iko chini ya this function
    jsonData = getResponse(urlData)
    if(jsonData is not ''):
        conectToPostGres(jsonData,version)
        return True

#this function handles a successful connection of the url
def getResponse(url):
    #opens the url
    operUrl = urllib.request.urlopen(url)
    #cheks if the GET response is successfull
    if(operUrl.getcode()==200):
        #opens the url and reads the content
        data = operUrl.read()
        #decods the JSON content
        jsonData = json.loads(data)
    else:
        print("Error receiving data", operUrl.getcode())
    return jsonData

#this function handles successfull connection and storing of data to postgreSQL
def conectToPostGres(jsonData,version):
    #handles connection
    #in your case you will change the password and database name umeshika!
    connection = psycopg2.connect(user="postgres",
                                    password="123",
                                    host="127.0.0.1",
                                    port="5432",
                                    database="ItcImports")

    if(version=="country"):
        for i in jsonData:
            try:
                    #this calls the cursor
                    cursor = connection.cursor()

                    #this query helps in storying values to the table
                    #in this case you will just change the household name to your table name and its column names
                    postgres_insert_query = """ INSERT INTO public.household("householdNumber", "safeWater", "treatedWater") VALUES (%s,%s,%s)"""
                    #define here the json objects and store them
                    record_to_insert = (i["country_iso"], i["country_name_english"], i["continent"])
                    #execute the cursor
                    cursor.execute(postgres_insert_query, record_to_insert)
                    #commit the connection
                    connection.commit()
                    #this counts the rows
                    count = cursor.rowcount
                    #this prints them if its successfull
                    print (count, "Record inserted successfully into member table")

            #this handles errors if it occurs
            except(Exception, psycopg2.Error) as error:
                if(connection):
                    print("Failed to insert record into the table",error)

            finally:
                #closing database connection
                if(connection):
                    cursor.close()
                    connection.close()
                    print("PostgresQl connection is closed")

    elif(version == "products"):

        for i in jsonData:
            try:
                    #this calls the cursor
                    cursor = connection.cursor()

                    #this query helps in storying values to the table
                    #in this case you will just change the household name to your table name and its column names
                    postgres_insert_query = """ INSERT INTO public.household("householdNumber", "safeWater", "treatedWater") VALUES (%s,%s,%s)"""
                    #define here the json objects and store them
                    record_to_insert = (int(i["product_code"]), i["group_code"], i["group_name"])
                    #execute the cursor
                    cursor.execute(postgres_insert_query, record_to_insert)
                    #commit the connection
                    connection.commit()
                    #this counts the rows
                    count = cursor.rowcount
                    #this prints them if its successfull
                    print (count, "Record inserted successfully into member table")

            #this handles errors if it occurs
            except(Exception, psycopg2.Error) as error:
                if(connection):
                    print("Failed to insert record into the table",error)

            finally:
                #closing database connection
                if(connection):
                    cursor.close()
                    connection.close()
                    print("PostgresQl connection is closed")

    elif(version == "trade"):

        for i in jsonData:
            try:
                    #this calls the cursor
                    cursor = connection.cursor()

                    #this query helps in storying values to the table
                    #in this case you will just change the household name to your table name and its column names
                    postgres_insert_query = """ INSERT INTO public.household("householdNumber", "safeWater", "treatedWater") VALUES (%s,%s,%s)"""
                    #define here the json objects and store them
                    record_to_insert = (i["reporter_iso"], int(i["product_code"]), int(i["import_value_usd"]))
                    #execute the cursor
                    cursor.execute(postgres_insert_query, record_to_insert)
                    #commit the connection
                    connection.commit()
                    #this counts the rows
                    count = cursor.rowcount
                    #this prints them if its successfull
                    print (count, "Record inserted successfully into member table")

            #this handles errors if it occurs
            except(Exception, psycopg2.Error) as error:
                if(connection):
                    print("Failed to insert record into the table",error)

            finally:
                #closing database connection
                if(connection):
                    cursor.close()
                    connection.close()
                    print("PostgresQl connection is closed")


#this one calls the main function
if __name__ == '__main__':
    #this is the main function
    main()