These settings should do it, as long as you set the offset to 0 in the "query parameters" section, you should be in the clear
I've changed the '100' to '1k', since that's the API batch size, and it worked like a charm, thank you ddellsperger !
I still have some questions if I may, since I'm not too familiar with the 'snap.out' property. I tend to fail at trying to read the values of this property during validation and see what it holds to get a better understanding, is that impossible? Another thing is the $entity property being accessible in the 'Has Next' clause but not in the others, can you elaborate on that please?
You can use a mapper with the nullsafe option turned on, and specify the fields that you need on the source and target. That should give you a null value. You can also simply replace the source value with a string like:
((‘LAST_NAME’ in $)?$LAST_NAME: null)
This is basically two commands:
How to Fetch all records while validating snap : | SnapLogic - Integration Nation - 22808
