Skip to content

Instantly share code, notes, and snippets.

@fairchild
Forked from zackchandler/gist:4126
Created August 7, 2008 11:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fairchild/4380 to your computer and use it in GitHub Desktop.
Save fairchild/4380 to your computer and use it in GitHub Desktop.
<?xml version="1.0" ?>
<?qbxml version="5.0" ?>
<QBXML>
<QBXMLMsgsRq onError="continueOnError">
<InvoiceQueryRq requestID="1" iterator="{iterator}" iteratorID="{iterator_id}">
<MaxReturned>50</MaxReturned>
<ModifiedDateRangeFilter>
<FromModifiedDate>{from_modified_date}</FromModifiedDate>
<ToModifiedDate>{to_modified_date}</ToModifiedDate>
</ModifiedDateRangeFilter>
<IncludeLineItems>true</IncludeLineItems>
<IncludeRetElement>TxnID</IncludeRetElement>
<IncludeRetElement>EditSequence</IncludeRetElement>
<IncludeRetElement>TxnNumber</IncludeRetElement>
<IncludeRetElement>CustomerRef</IncludeRetElement>
<IncludeRetElement>TxnDate</IncludeRetElement>
<IncludeRetElement>RefNumber</IncludeRetElement>
<IncludeRetElement>Subtotal</IncludeRetElement>
<IncludeRetElement>SalesTaxPercentage</IncludeRetElement>
<IncludeRetElement>SalesTaxTotal</IncludeRetElement>
<IncludeRetElement>AppliedAmount</IncludeRetElement>
<IncludeRetElement>BalanceRemaining</IncludeRetElement>
<IncludeRetElement>InvoiceLineRet</IncludeRetElement>
</InvoiceQueryRq>
</QBXMLMsgsRq>
</QBXML>
def parameterize(xml)
xml.gsub!('{iterator}', iterator_id.blank? ? 'Start' : 'Continue')
xml.gsub!('{iterator_id}', iterator_id || '')
xml.gsub!('{from_modified_date}', ((transactions_last_synced_on || 10.years.ago) - 1.day).to_s(:qb_date))
xml.gsub!('{to_modified_date}', (Time.now + 1.day).to_s(:qb_date))
xml
end
ActiveSupport::CoreExtensions::Time::Conversions::DATE_FORMATS.update(
:qb_date => '%Y-%m-%d'
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment