SQL dynamically query was quite powerful but sometimes we need pay attention to it. The below SQL code snippet example just perform execute dynamic command and then insert into temp table. The stored procedure execute over production environment just return empty query but without any errors coming back to the…

Environment: Win11 / VS CODE / NEXT.JS-14.0.1 — NEXT.JS is a open source of React (Javascript library) framework that help developer(s) to build up fast and modern web site architecture. NEXT.JS declared that with zero-config and hybrid static server side rending (SSR) that compatible with rich ecosystem provide variety of plugins and extensions. Official build up a step…

Using Posh-SSH module as example — We got several ways to interchange B2B data, AS2/Van (EDI format), API (XML, JSON format) or FTP/SFTP (Any kind (excel, PDF, txt…) of file format). The story introduced a general RPA (Robotic Process Automation) that using PowerShell to interactive with SFTP for B2B data transformation. First we used NUGET to…

Failed routing because there is no subscribing orchestration or send port — The scenario was simply that we design a orchestration as below. And we have merely one receive port and binding with physical port “DefaultPipelines.EdiRecieve”. The message type of the receive port was setup to standard X12_00401_860 EDI type.

Take EDI 855 as example — Image that we are running a GPU manufacturing factories. Our customer would like to purchase some chips via EDI transactions. After we received EDI 850 for the order. Then we need ack the order with correspond EDI 855 for the order under different branches (of company) that represent by sector…

As a data/backend engineers that extract/filter dirty data to clean data would be necessary for some scenario. The first thing was to write some rule based validations for the purpose. …

Version 7.3.0 — We have somehow need to invoke a HTTP request for testing, integration or robotic purposes. PowerShell provide diverse functions that help us make our developers’ life more easily. However, the below code snippet having an issue to deal with encoding problem: $headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]" $headers.Add("Content-Type", "application/json; charset=utf-8") $body = "{ `n…

Take EDI850 as example —

We have a file API that routine scheduling a archive file(s) job of the specific path(drive) for backup the data. The application occupied memory usage above 3GB under the monitoring dashboard from the date: December 11.