Snowflake connector extracting data

1

Hi all,

I implemented a connector with Snowflake where our employees datas are uploaded from KELIO tool.
I have some difficulties doing a good mapping for the Output and I don’t understand where is the mistake (chatGPT doesn’t either…).

Here are some screen shots of the body I get from the connector and the Outputs with my current configuration.

image
image1918×868 88.3 KB

image
image1905×866 83.5 KB

I don’t understand why everything is null in my Object List “Employee Data KELIO”.

In the end, what I would like to do, is to use an automation to loop through the employee list and create record in my employee table if it the identificationNumber doesn’t exist already.

Thanks a lot for your help !
Paul