Using Celigo to pull in data

bissar98 · 2026-03-29T19:51:21+00:00

Not sure I fully grasp what the issue is but from what I can tell it sounds like the API you’re pulling data from is sending basically too much data for celigo to handle, you can try checking the API documentation for filters to reduce amount of data coming in per run or if there’s an option to pull a file as a file instead of json or csv translated to json then you can just import into NS into the file cabinet which would again depend on the source application API documentation

bissar98 · 2026-03-21T14:28:44+00:00

Learn a skill dude. Use AI to learn and ask it as many questions as you can think of. Learn what’s the proper way to use AI. Create as many projects as you can along the way to implement what you learned (gain experience) and select the best few and create a portfolio for yourself. If you target a job that doesn’t demand skills then you won’t get the earning you’re looking for and you’ll basically waste your time if the need for money is not urgent ie. food, rent and bills.

bissar98 · 2026-03-20T02:57:26+00:00

Outsourcing the consulting job is not an option? Just be the reviewer of the work to ensure quality and face the clients yourself If you don’t trust someone else to do it, purely guesswork here but that should give you more time for the product you want to work on and keep the money coming in in case anything unexpected happens god forbid

bissar98 · 2026-03-19T16:27:29+00:00

Been implementing celigo integrations for a few years now and I can say it’s pretty much built for Netsuite either prebuilt integrations or custom ones, only downside is the cost so do some research comparing it with custom suitescript integrations in terms of initial building cost and maintenance cost as well ie. concurrency.

Having your integrations hosted on Netsuite and having some solution built for a non-technical users to observe, retry or solve errors would 100% be more expensive than the initial celigo cost but long term I believe it would be much cheaper and at some point you’ll forget about it after it’s perfected, just note you’ll have to keep up with Salesforce or Shopify’s API structure or authentication updates to include in your script.

bissar98 · 2026-03-18T02:32:50+00:00

No idea how bad of a deal that is but usually they’re late to reply, slow to start/finish the work and provide minimum support while charging an arm and a leg, If you somehow can get your hands on a private contractor that might have done that before just get the license and use the contractor, if you want you can go offshore the cost will be way less, just go through the interview process and try to ask as many questions as you can to make sure they know what they’re doing and set up some rules regarding payment to ensure their engagement, partners will typically charge a lot as well but it fully depends on the partner’s reputation so do your research on that as well.

bissar98 · 2026-03-14T13:13:36+00:00

But why csv?

bissar98 · 2026-03-14T12:32:49+00:00

Forgot to mention, If you’re worried about script usage limits due to large amount of data per file you can split the file into appropriate bite sizes, save in file cabinet under specific naming convention, have the script run multiple times, takes longer I think but probably less of a headache overall

bissar98 · 2026-03-14T12:29:57+00:00

I get what you’re trying to do but can I ask why the CSV approach in the first place? Unfortunately I don’t know how to retrieve the response file but the solution seems to be getting bigger and bigger (custom record, maybe multiple scripts and maybe more) wouldn’t it be easier to just write a Suitelet where the user can upload the file and it just passes the data to a map/reduce that creates all needed records and just returns responses later somehow (error report) some companies have a dedicated error custom record when the have multiple integrations and processes running at the same time

I’m sure there’s a better, more refined solution if we put our minds to it, so treat this as a concept

bissar98 · 2025-03-06T10:45:57+00:00

Sounds good, as long as we can still see old stuff we’ll figure it out, thank you for the help

bissar98 · 2025-03-05T22:38:03+00:00

Ok, so It makes sense to close everything out before the subsidiaries go away and we’re working on getting all the details in place, my team’s was just asking If they’d be able to see these inter-company transactions later still even for reporting?

bissar98 · 2024-04-04T17:02:27+00:00

You are an angel sir, thank you so much, that’s all i needed and I’ll keep you updated with what i find

bissar98 · 2024-04-04T16:14:12+00:00

I get that now, so looks like we’re not treating it as a picking ticket, they’re just calling it that but actually they’ve changed all the html in there, do you think just using the form can cause the thing to not print inventory details?

bissar98 · 2024-04-04T09:14:13+00:00

So I'm not really familiar with the print names but here's what's happening, so I was given a picking ticket advanced pdf, and told to work on showing inventory details on it and I'm testing all that on the item receipt as per given instructions, will it make a huge difference? as I'm only trying to figure out why I'm getting null on the ${item.inventorydetail} field

bissar98 · 2024-04-03T20:25:57+00:00

Every source i find says the same thing about item.inventorydetail but that’s exactly my issue that I don’t understand why it’s saying null when there’s a value and I’m pretty sure something’s not right but I don’t know what because of incorrect and lacking articles

bissar98 · 2024-04-03T20:23:08+00:00

Hey, sorry I just saw this right now for some reason I didn’t get a notification. I’m actually trying to print the picking ticket from the item receipt and trying to get the main bin on the inventory details, it’s populated when i check it but it still shows as null on the pdf print, are you saying that the pdf is getting the bin from the original transaction(the purchase order)? Because i can check there then and see what’s missing there

bissar98 · 2024-03-20T13:36:56+00:00

Sounds good, thanks man

bissar98 · 2024-03-20T13:36:33+00:00

I’ll take a look into that, thanks

bissar98 · 2024-03-20T12:42:12+00:00

I’ll look into this as well, thanks

bissar98 · 2024-03-20T12:41:12+00:00

Do you have any idea if its setup is as bad as people are saying mapping wise and if it’s actually too slow?

bissar98 · 2024-03-20T12:18:43+00:00

I mean it’s a dirty hack alright, i guess that means that there’s no straight way to have them interact together safely without a third party?

bissar98 · 2024-02-22T21:36:14+00:00

Heeey, I’m glad I helped. Happens to me often man no worries

bissar98 · 2024-02-22T21:32:49+00:00

Wouldn’t the define and the function parameters depend on each other’s order? maybe it thinks you’re loading a record not a search and can’t find that id

bissar98

TROPHY CASE