REST API + JSON + Database Bot

Main.xaml (Sequence)
 |
 +-- Try Catch
 |    +-- Sequence: Get Token
 |    |    +-- HTTP Request
 |    |         Url: https://api.crm.com/auth/token
 |    |         Method: POST
 |    |         Body: {"client_id": in_ClientId, "client_secret": in_Secret}
 |    |         ContentType: application/json
 |    |         ->  strTokenResp
 |    |    +-- Assign: strToken = Deserialize JSON Property(strTokenResp, "access_token")
 |    +-- Sequence: Fetch & Load
 |    |    +-- Assign  intPage = 1
 |    |    +-- While  blnMoreData
 |    |         +-- HTTP Request
 |    |         |      Url: "https://api.crm.com/leads?page=" + intPage + "&limit=100"
 |    |         |      Method: GET
 |    |         |      Headers: Authorization = "Bearer " + strToken
 |    |         |      ->  strLeadsResp
 |    |         +-- Assign: jArr = Deserialize JSON (strLeadsResp).SelectToken("data")
 |    |         +-- For Each  item in jArr
 |    |         |    +-- Assign: dtLeads.Rows.Add(item("id"), item("name"), item("email"), item("status"))
 |    |         +-- Assign: blnMoreData = strLeadsResp.Contains("next_page")
 |    |         +-- Assign: intPage = intPage + 1
 |    |         +-- Delay  1000 ms    (rate limit respect)
 |    |    +-- For Each Row in dtLeads
 |    |         +-- Try Catch
 |    |              +-- Execute Non Query (SQL):
 |    |              |      MERGE INTO Leads AS t
 |    |              |      USING (SELECT @id AS Id) AS s ON t.Id = s.Id
 |    |              |      WHEN MATCHED THEN UPDATE SET Name=@name, Status=@status
 |    |              |      WHEN NOT MATCHED THEN INSERT (Id, Name, Email, Status) VALUES (@id,@name,@email,@status);
 |    |              +-- Set Transaction Status / Write Row: "OK"
 |    |         +-- Catch
 |    |              +-- Add Queue Item  queue: "CRM_Lead_Failed"  Data: row
 |    +-- Catch (AuthException)
 |         +-- Log Message  LogLevel.Error  "Token expired - refresh flow run"
 |         +-- (Alert Orchestrator / terminate for retry)

# 1. Deserialize JSON Property - simple flat field:
strToken = Deserialize JSON Property(strResp, "access_token")

# 2. JSON Select Token - nested path (JSONPath):
strCity = JsonSelectToken(strResp, "data[0].address.city")

# 3. For Each (JArray) - array iterate karke DataTable me:
jArr = Deserialize JSON(strResp).SelectToken("data")
For Each item in jArr -> dt.Rows.Add(item("id"), item("name"))

# XPath/JSONPath samjho to 90% API integration easy hai.