Forum Discussion

Henchway's avatar
Henchway
Contributor
5 years ago

Settings a HTTP response code for triggered tasks

Hi everyone, we’re offering a triggered task as a sort of simplified API for a more complex REST API (specifically Jira). What we want to achieve is to influence the HTTP return code, status and ...
triggered
mbowen's avatar
mbowen
Employee
4 years ago
Copy LinkReport

Hi @tharunm

You had posted a previous message in community with less information. This connection error is being returned from the SQL server driver. “null” is suspect here, and suggests something isn’t defined or can’t be reached.

It may be a firewall issue. I assume you’ve verified the credentials. Can you verify that you are indeed able to connect to this host and port.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1300d370-3736-431b-8912-a0152779453c/unable-to-open-port-no1433?forum=sqlgetstarted

tharunm's avatar
tharunm
New Contributor II
4 years ago
Copy LinkReport

Hi @mbowen and @siwadon,

The current issue I encounter is, I am able to connect the SQL server outside snaplogic but not with snaplogic.

There were two errors, one while using groundplex(which is preferred) and an other using cloudplex.

Also, there are other SQL servers accounts which I’ve created in the past and still working on with them. So, for this account alone I see ‘Unexpected rethrowing’ error.

I really appreciate your responses. Thank you.

  • koryknick's avatar
    koryknick
    Employee
    2 years ago
    Copy LinkReport

    KevinFord - you could either just get the first index of the array

    $arrayField[0])

    or use the Array.pop() method

    $arrayField.pop()

    Hope this helps!