Delete rows not returned in API calls

jwilkinson1665370444 — Fri, 15 Nov 2024 22:19:41 GMT

Hi All,

I am using Talend to develop pipelines which make API calls to UPSERT data in snowflake. However, the rows no longer returned by these calls are not deleted. I have to develop a solution where this happens.

I cannot compare my source and target tables post insert since my source is an API Call.
Additionally, if I do a left inner join and catch lookup rejects in Tmap, I am getting 0 results. Doing an inner join does not capture entries in the snowflake table (lookup) which are not returned by API calls
When I trued to switch main and lookup, theTMAP is not accepting tlogrow, another map or textractjson as an input

Any help is appreciated.

Re: Delete rows not returned in API calls

Anonymous — Mon, 28 Nov 2022 07:30:48 GMT

Hello,

As you do a left inner join and catch lookup rejects in tmap, you are getting 0 results, could you please show us your tMap (map_api_data) setting screenshot?

What's does your expected result look like? Elaborating your case with an example with input and expected output values will be preferred.

Best regards

Sabrina

topic Delete rows not returned in API calls in Talend Studio

Delete rows not returned in API calls

Re: Delete rows not returned in API calls