Export All: Methods and Formats

jbooker · June 9, 2025, 3:24pm

Looks like json input for Ice.BO.BAQDesignerSvc/Update method is a text representation sufficient for both creating new and updating existing.

Here’s a diff of update vs copy input:

Notes:

identical schema except
- update wrapped in Parameters object
set QueryID
set RowMod = “A”
keeping guids is okay

gist.github.com

https://gist.github.com/joshbooker/2017c654f9f0b75ac240a77939694014/revisions

BAQUpdate.json

{
    "parameters": {
        "ds": {
            "DynamicQueryDesigner": [
                {
                    "Company": "XXXXXX",
                    "QueryID": "baq_PartTran_CostVar6copy",
                    "AuthorID": "xxxxxx",
                    "Description": "baq_PartTran_CostVariance     \ntest",
                    "DisplayPhrase": "/*  \n * Disclaimer!!! \n * This is not a real query being executed, but a simplified version for general vision. \n * Executing it with any other tool may produce a different result. \n */\nwith [SubQuery1] as \n(select  \n\t[PartTran].[Company] as [PartTran_Company], \n\t[PartTran].[PartNum] as [PartTran_PartNum], \n\t[PartTran].[MtlUnitCost] as [PartTran_MtlUnitCost], \n\t[PartTran].[MtlBurUnitCost] as [PartTran_MtlBurUnitCost], \n\t[PartTran].[SysDate] as [PartTran_SysDate], \n\t(LAG(MtlUnitCost, 1, 1) OVER (PARTITION BY Company, PartNum ORDER BY SysDate)) as [Calculated_PrevMtlCost], \n\t(LEAD(MtlUnitCost, 1, 1) OVER (PARTITION BY Company, PartNum ORDER BY SysDate)) as [Calculated_NextCost] \n\nfrom Erp.PartTran as [PartTran]\nwhere (PartTran.SysDate >= @StartDate  \nand PartTran.SysDate <= @EndDate) and ( not LAG(MtlUnitCost, 1, 1) OVER (PARTITION BY Company, PartNum ORDER BY SysDate) = 0  ))\n\nselect  \n\t[Part].[Company] as [Part_Company], \n\t[Part].[PartNum] as [Part_PartNum], \n\t[Part].[PartDescription] as [Part_PartDescription], \n\t[SubQuery1].[PartTran_SysDate] as [PartTran_SysDate], \n\t[SubQuery1].[PartTran_MtlUnitCost] as [PartTran_MtlUnitCost], \n\t[SubQuery1].[PartTran_MtlBurUnitCost] as [PartTran_MtlBurUnitCost], \n\t[SubQuery1].[Calculated_PrevMtlCost] as [Calculated_PrevMtlCost], \n\t[SubQuery1].[Calculated_NextCost] as [Calculated_NextCost], \n\t(SubQuery1.Calculated_PrevMtlCost - SubQuery1.PartTran_MtlUnitCost) as [Calculated_MtlCostDiff], \n\t((SubQuery1.Calculated_PrevMtlCost - SubQuery1.PartTran_MtlUnitCost)/SubQuery1.Calculated_PrevMtlCost) as [Calculated_MtlCostDiffPercent], \n\t(ABS((SubQuery1.Calculated_PrevMtlCost - SubQuery1.PartTran_MtlUnitCost)/SubQuery1.Calculated_PrevMtlCost)) as [Calculated_MtlCostDiffPercentABS] \n\nfrom Erp.Part as [Part]\nleft outer join  SubQuery1  as [SubQuery1] on \n\t  Part.Company = SubQuery1.PartTran_Company\n\tand  Part.PartNum = SubQuery1.PartTran_PartNum\n\tand ( SubQuery1.Calculated_PrevMtlCost = SubQuery1.Calculated_NextCost  )\nwhere ( ABS((SubQuery1.Calculated_PrevMtlCost - SubQuery1.PartTran_MtlUnitCost)/SubQuery1.Calculated_PrevMtlCost) >= @Variance  )",

This file has been truncated. show original