Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rubenfasilva
Contributor
Contributor

Retreive Basic rest information

Hello.

This is probably one simple thing, but I am stuck in this webservice to retreive portuguese national holidays: http://services.sapo.pt/Holiday/GetNationalHolidays?year=2021

I am using trestclient with: url=http://services.sapo.pt and relative path=Holiday/GetNationalHolidays and query param= year=2021 and header with Content-Type=application/json

Then I have textractjsonfields with xpath and json flfield=string and looppath query=getnationdayresult.

I missing something here, since I don't have any results...

Do you gays have any ideia why?

Thank you!

Labels (4)
5 Replies
gjeremy1617088143

HI, @Ruben Silva​ ,

could you put a tlogrow instead of textractjsonfield , and send us the json result ?

send me love and kudos

gjeremy1617088143

Ok, I tried it with postman with all your header parameters:

the response is an XML not a json.

Content-Type:text/xml; charset=utf-8

So use textractxmlfield instead.

Send me love and kudos

rubenfasilva
Contributor
Contributor
Author

Hello

sorry, i've tried that and no luck

Please find attached my screen shots0695b00000H94smAAB.png0695b00000H94sXAAR.png0695b00000H94sSAAR.png0695b00000H94sNAAR.pngThank you.....

gjeremy1617088143

I will try by my side, i'll respond you when i succeed.

gjeremy1617088143

0695b00000H95LeAAJ.jpg0695b00000H9591AAB.jpg0695b00000H95LZAAZ.jpg0695b00000H95HJAAZ.jpg