https://netsuiteprofessionals.com logo
Join Slack
Powered by
Does anyone have a good solid example of how to ad...
# integrations
n
Does anyone have a good solid example of how to add a lookup step in a Celigo flow, where I lookup Sales Order records and then if the SO# matches the order_number coming from my source data I want the NetSuite data to be merged into the source data? I worked with Celigo support on it and I just don't see the solutin they gave me working right...I'm not sure how to get this to work.. TIA
t
Can you send some screenshots of what you have? Not super sure I get what you're trying to do. If the SO does match, are you wanting the results from a saved search for that SO to populate back to the source system or you just need to map it into the source data going through IO so that you can then do something later?
n
Thanks for your help @Tyler Lamparter I ended up changing my idea around and now am trying to get the response mapping to work. In this step I am creating Item Fulfillments
message has been deleted
in the response mapping I am returning the internal Id of the Item fulfillment that get's created as ns_itemfulfillmentid
message has been deleted
But in my next step nothing happens
message has been deleted
It always says Success, but in the Sucess column it says 0 like nothing was processed.
message has been deleted
t
@nsAI that's because an error occurred on the step before it. If an error occurs on a step, the record pauses there until it's resolved. However, in your use case, it looks like you want the error to continue passing through. Click the + on the item fulfillment import, then the very last icon to the right will be "how to proceed if error". By default it will be pause, but you can choose the other option so the record gets passed to the next step regardless
n
@Tyler Lamparter I know that error message is probably causing confusion, but there were 2 errors. I corrected the retry data on one of them and reprocessed it. The error "cleared and the Item Fulfillment was sucessfully created, however, the next step of creating the integration log never happend
t
@nsAI what does the retry log say? The run console log doesn't show retries, you have to click the green/red dot on the import step and then go to retry tab
Well that won't show it either...shoot
Is the record in netsuite?
n
The item fulfillment record in the first step is in NetSuite...it was sucessfully created
The integration log record in the following step did NOT get created
t
what if you run from scratch, does it work then?
A new run instead of retry that is
n
whoa...that worked...why does the Retry data mess everything up?
t
Can you force an error on that step and try it again? Maybe enable debug on the connection and see what's it doing
n
Hi @Tyler Lamparter any idea why an Item Lookup would not work in the final step of my flow but it works in the previous step?
I re-created everything exactly how it is setup in my Sandbox (which works fine by the way) AND step 1 looks up the Item by Name (nternal) then returns the Internal ID, and that works fine
However, when i perform the EXACT same thing in the subsequent step it gives an error of "Message: Could not compile handle bar "{{shipments.0.shipped_lines[*].item_number}}" because "Parse error on line 1"
t
@nsAI is this a lookup on the mapping itself or an individual lookup step? If on an individual step, you can't use the [*] and would have to enable one-to-many path
If on the mapping step, then that seems right, but hard to tell without some screenshots
n
Thanks @Tyler Lamparter I was able to figure out another solution
7 Views
Open in Slack
PreviousNext
Powered by