using System.Data.SqlClient;
const string Attachments = "attachments";
public static void Main()
var searchdetailresults = "{\"Date\":\"2023-01-25T01:49:30.5419244Z\",\"Result\":{\"fileId\":\"85dc03f6-5707-485f-842f-d677e3669afb\",\"searchId\":\"1f85058b-947e-49e4-8a58-22d0128ab74a\",\"licenceClass\":\"1\",\"status\":\"Licenced\",\"demerits\":1,\"convictions\":[{\"Date\":\"2023-01-04T00:00:00\",\"Type\":\"Violation 1\"},{\"Date\":\"2023-01-19T00:00:00\",\"Type\":\"Violation 3\"}],\"issueDate\":\"2022-12-25T00:00:00\",\"expiryDate\":\"2023-01-25T00:00:00\",\"abstract\":\"\",\"adjudicatedResults\":[]}}";
path = GetPath(searchdetailresults);
var updatedPath = FormatFilePath(path);
Console.WriteLine(updatedPath);
public static string FormatFilePath(string path) {
return path.StartsWith(Attachments)? path : $"{Attachments}/{path}";
public static string GetPath(string searchDetailResults){
var path = JsonConvert.DeserializeAnonymousType(searchDetailResults.ToString(), new { Result = new { Abstract = "" } }).Result.Abstract;