cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 
Announcements
Everything you need to know about connecting your bank and credit cards in QuickBooks Online

Reply to Message

View discussion in a popup

Replying to:
E3ITLLC
Level 2

Reply to Message

EDIT

 

I forgot to change the invoiceDate type to 'date' in the previously posted query; here is the correction:

 

let
Source = Json.Document(File.Contents("C:\Users\MasonMitchell\OneDrive - E3IT.tech\Downloads\QBSE_Invoices (1).json")),
AsTable = Table.FromRecords(Source),
#"Removed Columns" = Table.RemoveColumns(AsTable,{"dateCreated", "dateUpdated"}),
#"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"amount", Currency.Type}}),
#"Removed Columns1" = Table.RemoveColumns(#"Changed Type",{"message", "allowOnlineCreditCardPayment", "allowOnlineACHPayment", "businessNumber", "logoSource", "paymentDetails", "salesTaxType", "rememberPaymentDetails", "v4LocalId", "events", "invoiceSender", "salesTaxItems"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns1",{{"dueDate", type date}, {"invoiceDate", type date}})
in
#"Changed Type1"

Need to get in touch?

Contact us