How to use json reader to pull data from an external source

[acseh]

HI,

I have been trying to use json reader to get data from an external source. I cant seem to get it to retrieve any data. Im not sure what I am missing our doing wrong. what nodes should I use.

Can anyone please help.

https://app.sandwai.com/datasync.php?companyid=99&keypass=99ABCD&senddata=
{
“visit”:[
{
“startdate”:“2018-10-01”,
“enddate”:“2018-10-31”,
“externalproviderid”:"",
“employeeid”:"",
“clientid”:"",
“serviceid”:"",
“costcodeid”:"",
“statusid”:"",
“includeevents”:""
}
]
}

Im pretty new to this.

Please note: I have changed the companyid and keypass as it is a secure connection.

[ScottF]

Hello @acseh -

Would a simple workflow like this help?

[acseh]

Hi,

Thanks for that. Yes it will. Also discovered that the JSON get call needs to be encoded. Works a treat thanks.