Hi @Ravneet_Kaur ,
Sharing my understanding first.
You are trying to make http request for one rest api end point you are getting output in Odata metadata error instead of json format. Not sure why http wizard showing correct json results but the output getting in different format.
While checking the below stack overflow link for the same issue they provided solution that adding one parameter like $format and value is json to get the json output as result. Could you give try following the below link. Thanks