• State Not Answered
  • Replies 2 replies
  • Subscribers 96 subscribers
  • Views 70 views
  • Users 0 members are here
Options
Related

Repeat SQLComponent Insert in a process

c polignano
2 days ago

Hello,

I have a scheduled process that once a day will be executed and will call an API. This API returns a string like the following "entry1,entry2,entry3" ecc. 

What I need to do is to insert those received value in a table, let's say that is called CCC_Api. So, after the process has been executed, in the table I want to find the record

UID (automatically generated), entry1

UID (automatically generated),entry2

UID (automatically generated),entry3

How to do that in a safe way? The SQLComponent Insert process step can insert only one record, so I need to find a way to a kind of loop in which every time the sql component Insert step insert a different record based on the Api result. 

Parents
  • 0 13 hours ago

    Calling the API is generally done from within a script. At that point, when you have the result, you would implement a loop, that cretes a new entity CCC_Api for each entry. This will create a unique UID for each new entry automatically. 

    If you need to need a unique counter, there is the table DialogNextID with its function "GetNextID". Search this forum for some examples.

    If the entries are more complex consider using a Powershell-SyncProject. Much more features, but also somewhat complicated.

  • 0 10 hours ago in reply to Klaus Müller

    Could you please tell me how can I use a script to do some insert in a db? Do you have any example?

Reply Children
No Data