Not returning all object it it will throw error

Four Stars

Not returning all object it it will throw error

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

Moderator

Re: Not returning all object it it will throw error

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.
Community Manager

Re: Not returning all object it it will throw error

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.

Community Manager

Re: Not returning all object it it will throw error

Hi @santosh did this solve your issue?

Four Stars

Re: Not returning all object it it will throw error

not Yet 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch