I am trying to modify the date for the FromModifiedDate line in the xml file
i would first like to show the date before changing but i dont know how to traverse this xml file to get to the FromModifiedDate
the console.writeline within the for next loop never gets hit
here is my code so far
Dim document1 As XDocument = XDocument.Load("C:QuickBooks SharedSDKTestPlus3BillQuery.xml")
' For Each ModifiedDateRangeFilter In From element In document1.<QBXML>.<QBXMLMsgsRq>.<BillQueryRq>.<ModifiedDateRangeFilter>
'ModifiedDateRangeFilter.<FromModifiedDate>.value = "2021-01-01"
' Next
For Each daterange As XElement In document1.Descendants("ModifiedDateRangeFilter")
Console.WriteLine(daterange.Elements("FromModifiedDate"))
Next
Console.WriteLine(document1.Root.Element("QBXMLMsgsRq").<BillQueryRq>.Value)
'.Elements("ModifiedDateRangeFilter").Elements("FromModifiedDate")
the second writeline outputs
2021-01-012023-12-311TxnIDTimeCreatedTimeModifiedVendorRefVendorAddressAPAccountRefTxnDateDueDateAmountDueIsPendingTermsRefIsPaidOpenAmount
and here is my XML file
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="16.0"?>
<QBXML>
<QBXMLMsgsRq onError="stopOnError">
<BillQueryRq>
<ModifiedDateRangeFilter> <!-- optional -->
<FromModifiedDate>2021-01-01</FromModifiedDate> <!-- optional -->
<ToModifiedDate>2023-12-31</ToModifiedDate> <!-- optional -->
</ModifiedDateRangeFilter>
<IncludeLineItems >1</IncludeLineItems> <!-- optional -->
<IncludeRetElement >TxnID</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >TimeCreated</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >TimeModified</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >VendorRef</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >VendorAddress</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >APAccountRef</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >TxnDate</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >DueDate</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >AmountDue</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >IsPending</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >TermsRef</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >IsPaid</IncludeRetElement> <!-- optional, may repeat -->
<IncludeRetElement >OpenAmount</IncludeRetElement> <!-- optional, may repeat -->
</BillQueryRq>
</QBXMLMsgsRq>
</QBXML>