HTTP Object - Revision history

WikiSysopdi at 08:37, 22 September 2025

2025-09-22T08:37:52Z

← Older revision		Revision as of 08:37, 22 September 2025
Line 90:		Line 90:

	}		}

			----

WikiSysopdi at 11:22, 3 September 2025

2025-09-03T11:22:28Z

← Older revision		Revision as of 11:22, 3 September 2025
Line 36:		Line 36:
	Example of automating updating the currency data in Sage CRM from an api		Example of automating updating the currency data in Sage CRM from an api

	~~<nowiki>~~

	di.addserver("CRM");//our crm server		di.addserver("CRM");//our crm server
Line 91:		Line 90:

	}		}

	~~</nowiki>~~

WikiSysopdi at 11:22, 3 September 2025

2025-09-03T11:22:16Z

← Older revision		Revision as of 11:22, 3 September 2025
Line 37:		Line 37:

	<nowiki>		<nowiki>

	di.addserver("CRM");//our crm server		di.addserver("CRM");//our crm server

	var req = HTTP();		var req = HTTP();

	req.Url="https://v6.exchangerate-api.com/v6/YOUR_KEY_HERE/latest/EUR";		req.Url="https://v6.exchangerate-api.com/v6/YOUR_KEY_HERE/latest/EUR";

	req.Method="GET";		req.Method="GET";

	var response = req.Send();		var response = req.Send();

	var json = response.JSON;		var json = response.JSON;

	di.display(response.body);		di.display(response.body);

	//di.display(json.result);//show the full result		//di.display(json.result);//show the full result

	di.display(json.conversion_rates.USD);		di.display(json.conversion_rates.USD);

	di.display(json.conversion_rates.CAD);		di.display(json.conversion_rates.CAD);

	di.display(json.conversion_rates.GBP);		di.display(json.conversion_rates.GBP);

	di.display(json.conversion_rates.AUD);		di.display(json.conversion_rates.AUD);

	di.display(json.conversion_rates.ZAR);		di.display(json.conversion_rates.ZAR);

	//update Sage CRM		//update Sage CRM

	if (json.result=="success")		if (json.result=="success")

	{		{

	var uSQL="update Currency set Curr_Rate='"+json.conversion_rates.USD+"' where Curr_Symbol='$'";		var uSQL="update Currency set Curr_Rate='"+json.conversion_rates.USD+"' where Curr_Symbol='$'";

	di.nativesql(uSQL);		di.nativesql(uSQL);

	uSQL="update Currency set Curr_Rate='"+json.conversion_rates.CAD+"' where Curr_Symbol='$CAN'";		uSQL="update Currency set Curr_Rate='"+json.conversion_rates.CAD+"' where Curr_Symbol='$CAN'";

	di.nativesql(uSQL);		di.nativesql(uSQL);

	uSQL="update Currency set Curr_Rate='"+json.conversion_rates.GBP+"' where Curr_Symbol='£'";		uSQL="update Currency set Curr_Rate='"+json.conversion_rates.GBP+"' where Curr_Symbol='£'";

	di.nativesql(uSQL);		di.nativesql(uSQL);

	uSQL="update Currency set Curr_Rate='"+json.conversion_rates.AUD+"' where Curr_Symbol='$AUD'";		uSQL="update Currency set Curr_Rate='"+json.conversion_rates.AUD+"' where Curr_Symbol='$AUD'";

	di.nativesql(uSQL);		di.nativesql(uSQL);

	uSQL="update Currency set Curr_Rate='"+json.conversion_rates.ZAR+"' where Curr_Symbol='ZAR'";		uSQL="update Currency set Curr_Rate='"+json.conversion_rates.ZAR+"' where Curr_Symbol='ZAR'";

	di.nativesql(uSQL);		di.nativesql(uSQL);

	}		}

	</nowiki>		</nowiki>

WikiSysopdi at 11:21, 3 September 2025

2025-09-03T11:21:30Z

← Older revision		Revision as of 11:21, 3 September 2025
Line 33:		Line 33:

	---		---

	Example of automating updating the currency data in Sage CRM from an api		Example of automating updating the currency data in Sage CRM from an api

			<nowiki>
			di.addserver("CRM");//our crm server
			var req = HTTP();
			req.Url="https://v6.exchangerate-api.com/v6/YOUR_KEY_HERE/latest/EUR";
			req.Method="GET";
			var response = req.Send();
			var json = response.JSON;
			di.display(response.body);

			//di.display(json.result);//show the full result
			di.display(json.conversion_rates.USD);
			di.display(json.conversion_rates.CAD);
			di.display(json.conversion_rates.GBP);
			di.display(json.conversion_rates.AUD);
			di.display(json.conversion_rates.ZAR);

			//update Sage CRM
			if (json.result=="success")
			{
			var uSQL="update Currency set Curr_Rate='"+json.conversion_rates.USD+"' where Curr_Symbol='$'";
			di.nativesql(uSQL);
			uSQL="update Currency set Curr_Rate='"+json.conversion_rates.CAD+"' where Curr_Symbol='$CAN'";
			di.nativesql(uSQL);
			uSQL="update Currency set Curr_Rate='"+json.conversion_rates.GBP+"' where Curr_Symbol='£'";
			di.nativesql(uSQL);
			uSQL="update Currency set Curr_Rate='"+json.conversion_rates.AUD+"' where Curr_Symbol='$AUD'";
			di.nativesql(uSQL);
			uSQL="update Currency set Curr_Rate='"+json.conversion_rates.ZAR+"' where Curr_Symbol='ZAR'";
			di.nativesql(uSQL);
			}

			</nowiki>

WikiSysopdi at 11:20, 3 September 2025

2025-09-03T11:20:44Z

← Older revision		Revision as of 11:20, 3 September 2025
Line 34:		Line 34:
	---		---
	Example of automating updating the currency data in Sage CRM from an api		Example of automating updating the currency data in Sage CRM from an api

	~~di.addserver("CRM");//our crm server~~
	~~var req = HTTP();~~
	~~req.Url="https://v6.exchangerate-api.com/v6/YOUR_KEY_HERE/latest/EUR";~~
	~~req.Method="GET";~~
	~~var response = req.Send();~~
	~~var json = response.JSON;~~
	~~di.display(response.body);~~

	~~//di.display(json.result);//show the full result~~
	~~di.display(json.conversion_rates.USD);~~
	~~di.display(json.conversion_rates.CAD);~~
	~~di.display(json.conversion_rates.GBP);~~
	~~di.display(json.conversion_rates.AUD);~~
	~~di.display(json.conversion_rates.ZAR);~~

	~~//update Sage CRM~~
	~~if (json.result=="success")~~
	{
	~~var uSQL="update Currency set Curr_Rate='"+json.conversion_rates.USD+"' where Curr_Symbol='$'";~~
	~~di.nativesql(uSQL);~~
	~~uSQL="update Currency set Curr_Rate='"+json.conversion_rates.CAD+"' where Curr_Symbol='$CAN'";~~
	~~di.nativesql(uSQL);~~
	~~uSQL="update Currency set Curr_Rate='"+json.conversion_rates.GBP+"' where Curr_Symbol='£'";~~
	~~di.nativesql(uSQL);~~
	~~uSQL="update Currency set Curr_Rate='"+json.conversion_rates.AUD+"' where Curr_Symbol='$AUD'";~~
	~~di.nativesql(uSQL);~~
	~~uSQL="update Currency set Curr_Rate='"+json.conversion_rates.ZAR+"' where Curr_Symbol='ZAR'";~~
	~~di.nativesql(uSQL);~~
	}

WikiSysopdi at 11:20, 3 September 2025

2025-09-03T11:20:30Z

← Older revision		Revision as of 11:20, 3 September 2025
Line 31:		Line 31:

	di.push("weather", table, "a");</blockquote>		di.push("weather", table, "a");</blockquote>

			---
			Example of automating updating the currency data in Sage CRM from an api

			di.addserver("CRM");//our crm server
			var req = HTTP();
			req.Url="https://v6.exchangerate-api.com/v6/YOUR_KEY_HERE/latest/EUR";
			req.Method="GET";
			var response = req.Send();
			var json = response.JSON;
			di.display(response.body);

			//di.display(json.result);//show the full result
			di.display(json.conversion_rates.USD);
			di.display(json.conversion_rates.CAD);
			di.display(json.conversion_rates.GBP);
			di.display(json.conversion_rates.AUD);
			di.display(json.conversion_rates.ZAR);

			//update Sage CRM
			if (json.result=="success")
			{
			var uSQL="update Currency set Curr_Rate='"+json.conversion_rates.USD+"' where Curr_Symbol='$'";
			di.nativesql(uSQL);
			uSQL="update Currency set Curr_Rate='"+json.conversion_rates.CAD+"' where Curr_Symbol='$CAN'";
			di.nativesql(uSQL);
			uSQL="update Currency set Curr_Rate='"+json.conversion_rates.GBP+"' where Curr_Symbol='£'";
			di.nativesql(uSQL);
			uSQL="update Currency set Curr_Rate='"+json.conversion_rates.AUD+"' where Curr_Symbol='$AUD'";
			di.nativesql(uSQL);
			uSQL="update Currency set Curr_Rate='"+json.conversion_rates.ZAR+"' where Curr_Symbol='ZAR'";
			di.nativesql(uSQL);
			}

WikiSysopdi at 09:09, 3 September 2025

2025-09-03T09:09:20Z

← Older revision		Revision as of 09:09, 3 September 2025
Line 1:		Line 1:
	The HTTP object is used to make HTTP requests to variosu web api's.		The HTTP object is used to make HTTP requests to variosu web api's (REST etc).

WikiSysopdi at 08:13, 28 May 2025

2025-05-28T08:13:07Z

← Older revision		Revision as of 08:13, 28 May 2025
Line 5:		Line 5:

	Consuming a weather api<blockquote>jint di		Consuming a weather api<blockquote>jint di

	var req = HTTP();		var req = HTTP();
	req.Url="https://api.open-meteo.com/v1/forecast?latitude=52.52&longitude=13.405&hourly=temperature_2m";
			req.Url="<nowiki>https://api.open-meteo.com/v1/forecast?latitude=52.52&longitude=13.405&hourly=temperature_2m</nowiki>";

	req.Method="GET";		req.Method="GET";

	var response = req.Send();		var response = req.Send();

	var json = response.JSON;		var json = response.JSON;

	di.display(response.body);		di.display(response.body);

	di.display(json.latitude);		di.display(json.latitude);

	var table=CreateTable();		var table=CreateTable();

	table.Columns.Add("latitude");		table.Columns.Add("latitude");

	table.Columns.Add("longitude");		table.Columns.Add("longitude");

	table.Rows.Add(json.latitude, json.longitude);		table.Rows.Add(json.latitude, json.longitude);

	//append to the island		//append to the island
	~~di.push("weather", table, "a");~~

	</blockquote>		di.push("weather", table, "a");</blockquote>

WikiSysopdi at 08:12, 28 May 2025

2025-05-28T08:12:45Z

← Older revision		Revision as of 08:12, 28 May 2025
Line 5:		Line 5:

	Consuming a weather api<blockquote>jint di		Consuming a weather api<blockquote>jint di

	var req = HTTP();		var req = HTTP();
			req.Url="https://api.open-meteo.com/v1/forecast?latitude=52.52&longitude=13.405&hourly=temperature_2m";
	req.Url="~~<nowiki>~~https://api.open-meteo.com/v1/forecast?latitude=52.52&longitude=13.405&hourly=temperature_2m~~</nowiki>~~";

	req.Method="GET";		req.Method="GET";

	var response = req.Send();		var response = req.Send();

	var json = response.JSON;		var json = response.JSON;

	~~//REM show the full response as a string~~

	di.display(response.body);		di.display(response.body);
			di.display(json.latitude);

	~~//REM show the response as a formatted object~~		var table=CreateTable();
			table.Columns.Add("latitude");
	di.~~display(json~~.~~toString~~());		table.Columns.Add("longitude");
			table.Rows.Add(json.latitude, json.longitude);
	~~//REM show part of the respone~~

	di.~~display~~(json.latitude);

			//append to the island
			di.push("weather", table, "a");

	</blockquote>		</blockquote>

WikiSysopdi at 08:32, 26 May 2025

2025-05-26T08:32:18Z

← Older revision		Revision as of 08:32, 26 May 2025
Line 16:		Line 16:
	var json = response.JSON;		var json = response.JSON;

	//REM show the full response		//REM show the full response as a string

	di.display(response.body);		di.display(response.body);

	//REM show the object		//REM show the response as a formatted object

	di.display(json.toString());		di.display(json.toString());