Skip to Content
avatar image
Former Member

How to bulk insert /batch operation via add-on?

How can i update thousands records in a UDT via add on? Add on will get records from a webservice then update the UDT. But it takes too much time one by one. Is there a way bulk insert?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 16, 2017 at 11:20 AM

    Hi Huseyin,

    By the default object UserTable there is no option to do this. But if your UDT is of type "no object" you can run an update statement with the RecordSet object.

    Look this blog provided by ANKIT CHAUHAN, where he explained what is allowed with UDT.

    https://blogs.sap.com/2016/07/28/guidelines-for-modifying-sap-business-one-data/

    Hope it helps.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 16, 2017 at 06:55 AM

    Thank you for your asnwer. But I need to insert data as bulk.

    Add comment
    10|10000 characters needed characters exceeded