<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic API request specific parameters as input parameters for response custom code in Digital Exchange</title>
    <link>https://community.blueprism.com/t5/Digital-Exchange/API-request-specific-parameters-as-input-parameters-for-response/m-p/125263#M4672</link>
    <description>&lt;P&gt;Hi, everyone! I need help with something.&lt;BR /&gt;&lt;BR /&gt;I need to know if there is a way to reference action specific parameters, declared in the parameters tab of an API request, in a custom code request response.&lt;BR /&gt;&lt;BR /&gt;I made a code to extract some data from the response, but I can't make it work. The used code is shown below:&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Dim dt As New DataTable()

' Define ALL columns
dt.Columns.Add("idConta", GetType(String))
dt.Columns.Add("situacaoProcessamento", GetType(String))
dt.Columns.Add("pagamentoEfetuado", GetType(Boolean))
dt.Columns.Add("dataVencimentoFatura", GetType(DateTime))
dt.Columns.Add("dataVencimentoReal", GetType(DateTime))
dt.Columns.Add("dataFechamento", GetType(DateTime))
dt.Columns.Add("valorTotal", GetType(Double))
dt.Columns.Add("valorPagamentoMinimo", GetType(Double))
dt.Columns.Add("valorDebitosFatura", GetType(Double))
dt.Columns.Add("valorPagamentoEfetuado", GetType(Double))
dt.Columns.Add("saldoAtualizado", GetType(Double))
dt.Columns.Add("atual", GetType(Boolean))

' Parse JSON
Dim json As JObject = JObject.Parse(Response_Content)
Dim content As JArray = json("content")

' Date filter
Dim dataInicio As DateTime = DateTime.Parse(Initial_Date)
Dim dataFim As DateTime = DateTime.Parse(Final_Date)

For Each item As JObject In content

    If Not IsNothing(item("dataVencimentoReal")) Then
        
        Dim dataVenc As DateTime = DateTime.Parse(item("dataVencimentoReal").ToString())

        If dataVenc &amp;gt;= dataInicio AndAlso dataVenc &amp;lt;= dataFim Then
            
            Dim row As DataRow = dt.NewRow()

            ' Strings
            row("idConta") = item("idConta").ToString()
            row("situacaoProcessamento") = item("situacaoProcessamento").ToString()

            ' Booleans
            row("pagamentoEfetuado") = If(item("pagamentoEfetuado") IsNot Nothing, CBool(item("pagamentoEfetuado")), False)
            row("atual") = If(item("atual") IsNot Nothing AndAlso Not IsDBNull(item("atual")), CBool(item("atual")), False)

            ' Dates
            If item("dataVencimentoFatura") IsNot Nothing Then
                row("dataVencimentoFatura") = DateTime.Parse(item("dataVencimentoFatura").ToString())
            End If

            row("dataVencimentoReal") = dataVenc

            If item("dataFechamento") IsNot Nothing Then
                row("dataFechamento") = DateTime.Parse(item("dataFechamento").ToString())
            End If

            ' Numbers (safe conversion)
            row("valorTotal") = If(item("valorTotal") IsNot Nothing, CDbl(item("valorTotal")), 0)
            row("valorPagamentoMinimo") = If(item("valorPagamentoMinimo") IsNot Nothing AndAlso item("valorPagamentoMinimo").ToString() &amp;lt;&amp;gt; "", CDbl(item("valorPagamentoMinimo")), 0)
            row("valorDebitosFatura") = If(item("valorDebitosFatura") IsNot Nothing, CDbl(item("valorDebitosFatura")), 0)
            row("valorPagamentoEfetuado") = If(item("valorPagamentoEfetuado") IsNot Nothing AndAlso item("valorPagamentoEfetuado").ToString() &amp;lt;&amp;gt; "", CDbl(item("valorPagamentoEfetuado")), 0)
            row("saldoAtualizado") = If(item("saldoAtualizado") IsNot Nothing, CDbl(item("saldoAtualizado")), 0)

            dt.Rows.Add(row)
        End If
    End If

Next

Invoices = dt&lt;/LI-CODE&gt;&lt;P&gt;As you can see, I have declared the parameters in the parameters tab for the API request, but they are not showed in the bottom corner, like the other parameters.&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/42155i66A841FFBFD14F92/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/42156i98E50B87B27B6265/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;Did I do something wrong or it's just not possible to do it?&lt;/P&gt;</description>
    <pubDate>Fri, 10 Apr 2026 13:33:48 GMT</pubDate>
    <dc:creator>gu.toledo</dc:creator>
    <dc:date>2026-04-10T13:33:48Z</dc:date>
    <item>
      <title>API request specific parameters as input parameters for response custom code</title>
      <link>https://community.blueprism.com/t5/Digital-Exchange/API-request-specific-parameters-as-input-parameters-for-response/m-p/125263#M4672</link>
      <description>&lt;P&gt;Hi, everyone! I need help with something.&lt;BR /&gt;&lt;BR /&gt;I need to know if there is a way to reference action specific parameters, declared in the parameters tab of an API request, in a custom code request response.&lt;BR /&gt;&lt;BR /&gt;I made a code to extract some data from the response, but I can't make it work. The used code is shown below:&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;Dim dt As New DataTable()

' Define ALL columns
dt.Columns.Add("idConta", GetType(String))
dt.Columns.Add("situacaoProcessamento", GetType(String))
dt.Columns.Add("pagamentoEfetuado", GetType(Boolean))
dt.Columns.Add("dataVencimentoFatura", GetType(DateTime))
dt.Columns.Add("dataVencimentoReal", GetType(DateTime))
dt.Columns.Add("dataFechamento", GetType(DateTime))
dt.Columns.Add("valorTotal", GetType(Double))
dt.Columns.Add("valorPagamentoMinimo", GetType(Double))
dt.Columns.Add("valorDebitosFatura", GetType(Double))
dt.Columns.Add("valorPagamentoEfetuado", GetType(Double))
dt.Columns.Add("saldoAtualizado", GetType(Double))
dt.Columns.Add("atual", GetType(Boolean))

' Parse JSON
Dim json As JObject = JObject.Parse(Response_Content)
Dim content As JArray = json("content")

' Date filter
Dim dataInicio As DateTime = DateTime.Parse(Initial_Date)
Dim dataFim As DateTime = DateTime.Parse(Final_Date)

For Each item As JObject In content

    If Not IsNothing(item("dataVencimentoReal")) Then
        
        Dim dataVenc As DateTime = DateTime.Parse(item("dataVencimentoReal").ToString())

        If dataVenc &amp;gt;= dataInicio AndAlso dataVenc &amp;lt;= dataFim Then
            
            Dim row As DataRow = dt.NewRow()

            ' Strings
            row("idConta") = item("idConta").ToString()
            row("situacaoProcessamento") = item("situacaoProcessamento").ToString()

            ' Booleans
            row("pagamentoEfetuado") = If(item("pagamentoEfetuado") IsNot Nothing, CBool(item("pagamentoEfetuado")), False)
            row("atual") = If(item("atual") IsNot Nothing AndAlso Not IsDBNull(item("atual")), CBool(item("atual")), False)

            ' Dates
            If item("dataVencimentoFatura") IsNot Nothing Then
                row("dataVencimentoFatura") = DateTime.Parse(item("dataVencimentoFatura").ToString())
            End If

            row("dataVencimentoReal") = dataVenc

            If item("dataFechamento") IsNot Nothing Then
                row("dataFechamento") = DateTime.Parse(item("dataFechamento").ToString())
            End If

            ' Numbers (safe conversion)
            row("valorTotal") = If(item("valorTotal") IsNot Nothing, CDbl(item("valorTotal")), 0)
            row("valorPagamentoMinimo") = If(item("valorPagamentoMinimo") IsNot Nothing AndAlso item("valorPagamentoMinimo").ToString() &amp;lt;&amp;gt; "", CDbl(item("valorPagamentoMinimo")), 0)
            row("valorDebitosFatura") = If(item("valorDebitosFatura") IsNot Nothing, CDbl(item("valorDebitosFatura")), 0)
            row("valorPagamentoEfetuado") = If(item("valorPagamentoEfetuado") IsNot Nothing AndAlso item("valorPagamentoEfetuado").ToString() &amp;lt;&amp;gt; "", CDbl(item("valorPagamentoEfetuado")), 0)
            row("saldoAtualizado") = If(item("saldoAtualizado") IsNot Nothing, CDbl(item("saldoAtualizado")), 0)

            dt.Rows.Add(row)
        End If
    End If

Next

Invoices = dt&lt;/LI-CODE&gt;&lt;P&gt;As you can see, I have declared the parameters in the parameters tab for the API request, but they are not showed in the bottom corner, like the other parameters.&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/42155i66A841FFBFD14F92/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/42156i98E50B87B27B6265/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="image.png" alt="image.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;Did I do something wrong or it's just not possible to do it?&lt;/P&gt;</description>
      <pubDate>Fri, 10 Apr 2026 13:33:48 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Digital-Exchange/API-request-specific-parameters-as-input-parameters-for-response/m-p/125263#M4672</guid>
      <dc:creator>gu.toledo</dc:creator>
      <dc:date>2026-04-10T13:33:48Z</dc:date>
    </item>
  </channel>
</rss>

