Scheduled Job script to call JSON Method GET

[manji5]

Hi All,

I have a REST message of type GET (Location data )

Next Step is to create a Scheduled job to parse this REST message in a Import set table and later transform it to the Location table.

Any idea on the script to call the GET method JSON via a scheduled job or any other way to do it.

Thank you,

Regards,

Ranjit

[Community Alums]

Hello @manji5 

Could you please try below code snippet 

               var request, response, status;
		request = new sn_ws.RESTMessageV2();
		request.setEndpoint('https://xyz.com'); 
		request.setHttpMethod('GET');
		request.setRequestHeader("Accept","application/json");
		request.setRequestHeader('Content-Type','application/json');
		response = request.execute();
		gs.info('Response body' + response.getBody());
		var JSONData = new global.JSON().decode(response.getBody());
		gs.info('Country Code: '+ JSONData.countryCode + ' Country Name: '+JSONData.countryName);
		return JSONData.countryCode + ' , ' + JSONData.countryName;

Please Mark ✅ Correct & 👍 Helpful, if applicable.

[manji5 · Accepted solution]

Hi Akshay,

I finally used the Flow Designer and the REST API action which was simple and straight forward as I didn't need scripting  to generate the Object and parse it via the Flow 

Appreciate your help 

Thank you,

Regards,

Manji