0 votes

Hello Efficy Team,

A customer have a big Excel file to import with a DataSynchro. My quesion is simple : how, with an Efficy method / function, could we insert a value in a Lookup if this value does not exist ?

Last time I had to do that, I did it with an insert in SQL :(
Not really clean.

Is there a more "efficient" way to do that ?

Thanks in advance,

Loïc

asked in WorkFlow / Serverscript by (460 points)

1 Answer

0 votes

Nope, that's the only way to do it. There is not API available in ServerJS.

However, there is undocumented support to add items to a lookup through SOAP, but this will not help you.

answered by (6.8k points)
I'll open a suggestion in the R&D
They know that we need an API on designer,  for lookups, groups and users
1,167 questions
1,425 answers
1,717 comments
325 users