Error accessing data from Web but works with Postman!

[Pouria]

hello Guys, 

this is my first time on this community and first question, so sorry if i dont know some ruls in here 🙂
I am trying to use this URL:

https://qualysapi.qualys.eu/api/2.0/fo/scan/?action=fetch&scan_ref=scan/1571065003.11385&output_form...
to get data from Qualys but  get this error:

however the same command works in Postman!!!

I really need to get this data to PowerBI, these are scan results from Qualys.

do you have any idea maybe?

regards, 

Pouria 

[v-yiruan-msft]

Hi @Pouria ，

You can refer the content in the following threads to get it and check whether it can connect successfully:

How to Integrate Power BI with Qualys

Error accessing data from Web

Best Regards

[Pouria]

hi yingyinr, 

thank s for your answer, Ive read and used that Doc. It works and I haved also transfered data from Qualys to PowerBi with that.

But almost everywher that I have a "Fetch" request it doesnt work. 

Do you have any Idea there?

regards, 

Pouria 

[v-yiruan-msft · Accepted solution]

Hi @Pouria ,

Could you please provide the related screenshot about the step <"Fetch" request>? By the way, did you also add the custom header "X-Requested-With" when connect to data source?

Best Regards

[Pouria]

hallo @v-yiruan-msft, 

sure, i can provide you with more details:

My powerBi Inputs are:

URL:
https://qualysapi.qualys.eu/api/2.0/fo/scan/?action=

fetch&scan_ref=scan/1621433037.28987&output_format=csv
headers:
Authorization > Basic bnR0Y20tcG06I05UVHNlYzEyMw==
X-Requested-With > Sample
which doesnt work.

However, the same input works in Postman:
URL:

curl -L -m 2 -X POST 'https://qualysapi.qualys.eu/api/2.0/fo/scan/' -H 'X-Requested-With: QualysPostman' -H 'Authorization: Basic bnR0Y20tcG06I05UVHNlYzEyMw==' -F 'action="fetch"' -F 'scan_ref="scan/1621433037.28987"' -F 'output_format="csv"'

(please see the attachment)