Create
The Create logic block is used in the Integrate logic block to insert successfully integrated records into another table. To create this type of logic block for your integration table, you must create a new logic block with the following configurations:
| Action | Type | Table Name | Security Option | Use NATE container |
|---|---|---|---|---|
Create<table name> | Background Task | <table name>Integration | Private | False |
Note: This logic block could also be Transaction type if a popup notification is needed.
In the Logic Builder, build your logic block according to the steps outlined below:
The requirements below cover if the records being integrated have an IntegrationAction of Create and will handle creation of the record in the system if one does not already exist. Optionally, with the IntegrationAction of Create, the logic block can be coded in such a way that the table can be fetched and if the record is found, then an update to that record can occur. The requirements below do not cover if the IntegrationAction of Update is passed in. While this is a possible use case, this would require that ALL records being integrated are known to already exist in the system.
| Requirements | Pseudo-code |
|---|---|
|
|
Integrate
The Integrate logic block is used in the Process Run list form action of the integration application to begin the integration process. To create this type of logic block for your integration table , you must create a new logic block with the following configurations:
It is important to note, that while these standards are written to incorporate using the queue parallel processing action, we always need to think about table contention. Parallel processing can only work when there is no contention. If your process could be updating the same record on another table for multiple records that are being imported, you could have contention issues. This means there would be multiple threads that are spawned that are all trying to update the same record at the same time which will lock each other out or cause a time out. To eliminate this type of contention you can use a bucket in your parallel processing action. Define your bucket so that all rows that will update the same record will run sequentially in the same thread and ensure there is no contention. The order of processing records is not guaranteed.
| Action | Type | Table Name | Security Option | Use NATE container |
|---|---|---|---|---|
Integrate<table name> | Background Task | <table name>Integration | Public-Secured | False |
In the Logic Builder, build your logic block according to the steps outlined below:
| Requirements | Pseudo-code |
|---|---|
|
|
Process Group
The Process Group logic block is used in the Integrate logic block and is used to process each group. This logic block calls the Create logic block and performs the error handling. To create this type of logic block for your integration table , you must create a new logic block with the following configurations:
| Action | Type | Table Name | Security Option | Use NATE container |
|---|---|---|---|---|
Process<table name>Group | Background Task | <table name>Integration | Private | False |
In the Logic Builder, build your logic according the steps outlined below:
| Requirements | Pseudo-code |
|---|---|
|
|
Integration Summary
The Integration Summary logic block is called by the Queue Parallel Processing action once all groups are processed in parallel. To create this type of logic block for your integration table , you must create a new logic block with the following configurations:
| Action | Type | Table Name | Security Option | Use NATE container |
|---|---|---|---|---|
Integration<table name>Summary | Background Task | <table name>Integration | Private | False |
Note: This logic block could also be Transaction type if a popup notification is needed.
In the Logic Builder, build your logic according the steps outlined below:
| Requirements | Pseudo-code |
|---|---|
|
|
Reset status
The Reset status logic block is used in the Reset Run Status list form action of the integration application to reset record statuses. To create this type of logic block for your integration table , you must create a new logic block with the following configurations:
| Action | Type | Table Name | Security Option | Use NATE container |
|---|---|---|---|---|
Reset<table name>IntegrationStatus | Background Task | <table name>Integration | Public-Secured | False |
In the Logic Builder, build your logic according the steps outlined below:
| Requirements | Pseudo-code |
|---|---|
|
|
Purge
The Purge logic block is used in the Purge Run list form action of the integration application to purge specific records from the integration table. To create this type of logic block for your integration table , you must create a new logic block with the following configurations:
| Action | Type | Table Name | Security Option | Use NATE container |
|---|---|---|---|---|
Purge<table name> | Background Task | <table name>Integration | Public-Secured | False |
In the Logic Builder, build your logic block according the steps outlined below:
| Requirements | Pseudo-code |
|---|---|
|
|