Thingworx and Visual Studio Code with any Source Control, CI / CD

Hi @wposner-2 

Here is the code that i use to extract JS code and SQL code from the XML

docNew.XPathSelectElements($"//ThingShape/ServiceImplementations/ServiceImplementation").ForEach(codeElement =>
{
	var handler = codeElement.Attribute("handlerName").Value;
	var name = codeElement.Attribute("name").Value;
	if (string.Equals("Script", handler))
	{
		// Javascript
		codeElement.XPathSelectElement("*//Rows/Row/code").WriteJS($"{entityFolderPath}/{name}.js", merge);
	}
	else
	{
		// SQLCommand, SQLQuery
		codeElement.XPathSelectElement("*//Rows/Row/sql").WriteSQL($"{entityFolderPath}/{name}.sql", merge);
	}
});

You may need to extract mashup code, so that you would be able to track/merge UI changes 

// Mashups
docNew.XPathSelectElements($"//{entityCollection}/{entityType}/Things").Where(_ => _.HasElements)
 .ForEach(codeElement => codeElement.WriteXML($"{entityGroupFolderPath}/{entityName}.xml", merge));
docNew.XPathSelectElements($"//{entityCollection}/{entityType}/mashupContent")
 .ForEach(codeElement => codeElement.WriteJSON($"{entityGroupFolderPath}/{entityName}.json", merge));

Hope this helps!

My Bests,

Hung Tran