topic Re: Not returning all object it it will throw error in Talend Studio

Not returning all object it it will throw error

Anonymous — Wed, 14 Feb 2018 13:08:39 GMT

i hit the database it show 4 row in database but it return only 2 . so help me

Re: Not returning all object it it will throw error

Anonymous — Fri, 16 Feb 2018 19:22:41 GMT

Hey santosh, can you walk through what you did? This will help others better assist you. I see the look up but I didn’t see any join conditions unless I missed them... In general the more details you provide the more likely someone will respond.

Re: Not returning all object it it will throw error

Anonymous — Fri, 16 Feb 2018 19:39:41 GMT

You need to join your "main" CountryCode column to your "lookup" CountryCode column and carry out an inner join. Your web service is erroring because you are returning every row of your lookup. REST services are only supposed to respond once per call. Of course you might want all of your lookup rows returned in one big XML output. If that is the case you need to set "All in one" to true in your response output. That will allow your XML to hold a look per lookup.

Re: Not returning all object it it will throw error

Anonymous — Fri, 23 Feb 2018 17:02:53 GMT

Hi @santosh did this solve your issue?

Re: Not returning all object it it will throw error

Anonymous — Wed, 20 Jun 2018 07:27:09 GMT

not Yet