Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
rubenfasilva
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
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