search

quran / quran.com-api

Quran.com content APIs
https://api-docs.quran.foundation/docs/category/content-apis
MIT License
923 stars 192 forks source link

duplicate "page number" column header #607

Open AhmadAskar opened 1 year ago

AhmadAskar commented 1 year ago

Great work guys, when trying to pull the verse of all verses requests by "chapter, juz, verse or anything" inside Power BI it gives an error that there are two columns with "page number" header and when i run through the browser i found two columns indeed can you help with that and maybe make it one column?

thank you Best. Ahmad.

AhmadAskar commented 1 year ago

I'd really appreciate your feedback on this issue, as it is causing show stopper to videos i am doing on the API thanks a lot in advance

naveed-ahmad commented 1 year ago

Can you send the sample API URL? I can see only one "page_number" field per ayah

Here is my sample API which fetch verses by chapter

https://api.quran.com/api/v4/verses/by_chapter/1?fields=page_number,text_uthmani

AhmadAskar commented 1 year ago

I can not thank you enough for getting back to me attached is the snapshot of the function call from a tool called power query it is the the etl tool in power bi and excel i called a web.contents() then passed the results to a json.document() just in case you need to investigate more and it is giving a duplicate "page number"

image

AhmadAskar commented 1 year ago

Salam Alykom any chance this might be solved as it is still exists when i am using power query, thank a lot