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,


asked in WorkFlow / Serverscript by (531 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 (7.4k 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,246 questions
1,517 answers
328 users