โ09-13-2022 05:46 AM
Hi!
Iโm building an integration here that gets contacts from Hubspot and update them as customers to Netsuite. Iโm getting data from Netsuite by querying a saved search. After getting the data i need to sort to diff. The problem is that when i validate it takes a few minutes to the Netsuite Search to become green and, before that happens, the Sort snap will fail and become red. I tried using the Async Search and had the same issue.
Do you know why its happening?
This is the error shown at Sort snap:
Failure: class java.util.LinkedHashMap cannot be cast to class java.lang.Comparable (java.util.LinkedHashMap and java.lang.Comparable are in module java.base of loader โbootstrapโ), Reason: Snap failed unexpectedly and did not provide any reason
โ09-13-2022 05:48 AM
The image i sent shows the pipeline while its validating, all snaps will eventually become green, except the Sort one.
โ09-13-2022 05:50 AM
Can you show the properties of your Sort snap? A sample of the incoming documents to the Sort would also be helpful.
โ09-13-2022 06:22 AM
These are the incoming docs:
This is the sort snap:
This is what happens when i try the same query but async:
โ09-13-2022 06:26 AM
Try this in the sort:
$record.email[โplatformCore:searchValueโ]
It looks like youโre trying to have the Sort work on an object, which I believe it can only handle scalar values.