cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

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