Retrieve Data
To retrieve insights by Photon Commerce
Access extracted JSON of uploaded files
Fetch the JSON content of already processed files without needing to re-upload the document.
curl -H "CLIENT-ID:<your-client-id>" \
-H "AUTHORIZATION:apikey <your-username>:<your-api-key>" \
-H 'PASSWORD:<your-password>' \
-H "SECRET-KEY:<your-secret-key" \
"https://api.photoncommerce.com/api/v2/scanapis/json?photon_key=<photon_key>"
Fetch JSON content
GET
https://api.photoncommerce.com/api/v1/json
Fetch JSON content of a specific file by passing the file id as a query parameter. Send a GET request using the same authentication technique(using username, password, api key, client id and secret key) to fetch the json data for previously uploaded invoices/receipts using the photon_key.
Query Parameters
photon_key
string
The photon_key of the uploaded file to fetch the JSON of.
Headers
Secret key
string
The secret key of your account
Password
string
The password to your account
Authorization
string
Pass your email address and unique API key in the form 'apikey <your_email>:<your_api_key>'
Client_ID
string
Unique Client_ID for every user. Incorrect value will lead to an authorization error.
[
{
"Account_Number": "",
"Bill_To_Address": "100 E Graham Place\nBurbank CA 91502",
"Bill_To_Name": "HARTELL",
"Card_Number": "",
"Category": "Warehouse",
"Currency_Code": "USD",
"Date": "2020-10-05",
"Discount": 0.0,
"Due_Date": "",
"Invoice_Number": "7862",
"Line_Items": [
{
"Amount": 432.0,
"Description": "Sales Order: 38587",
"Line": 1,
"Price": 432.0,
"QTY": 1.0,
"SKU": "100445",
"Unit": ""
},
{
"Amount": 0.0,
"Description": "100445 / MOTOR 208/230VAC\nSHADED POLE BASED ON",
"Line": 2,
"Price": 0.0,
"QTY": 1.0,
"SKU": "",
"Unit": ""
},
{
"Amount": 0.0,
"Description": "NEW CONNECTOR",
"Line": 3,
"Price": 0.0,
"QTY": 1.0,
"SKU": "100220",
"Unit": ""
},
{
"Amount": 0.0,
"Description": "MADE IN CHINA HTS\n8501.40.4040",
"Line": 4,
"Price": 0.0,
"QTY": 1.0,
"SKU": "100445",
"Unit": ""
}
],
"PO_Number": "2393905",
"Payment_Display_Name": "",
"Payment_Terms": "",
"Payment_Type": "",
"Phone_Number": "585-398-2000",
"Raw_Text": "Global Point Technology\t\tPhone::\t585.398.2000\n5815 County Road 41\t\t\tFax:\t585.398.2025\nFarmington NY 14425\n\tUSA\nGLOBAL POINT\nTECHNOLOGY\nPack Slip: 7862\t\t\t\tPacking Slip\t\t\tPage:\t1 of 1\nShip To:\t\t\t\t\t\tSold To:\nHARTELL\t\t\t\t\t\tMilton Roy - Flow Control Division\n100 E Graham Place\t\t\t\t\t201 Ivyland Road\nBurbank CA 91502\t\t\t\t\tIvyland PA 18974 USA\nUSA\n\nPhone:\t\t\t\t\t\tPhone:\nFax:\t\t\t\t\t\t\tFax:\nEmail:\t\t\t\t\t\t\tEmail:\nPO:\t2393905\tShip Via:\tRECON LOGISTICS\tFOB:\tGlobal Point Tech. USA\nShip Date: 5/20/2020\tTracking No:\t\t\tSales Rep: House Account\n\nLine\tPlanned Qty\tShipped Qty\tBackorder\tPart Number\t\tRevision\n\nSales Order: 38587\n1\t432.00\t432.00\t0.00 100445\n\t100445 / MOTOR 208/230VAC\n\tSHADED POLE BASED ON\n\t100220 NEW CONNECTOR\n\t100445 MADE IN CHINA HTS:\n\t8501.40.4040",
"Reference_Number": "VBCBB-3659",
"Shipping": 0.0,
"Subtotal": 0.0,
"Tax": 0.0,
"Tip": 0.0,
"Total": 0.0,
"Tracking_Number": "",
"Vat_Number": "",
"Vendor_Account_Number": "",
"Vendor_Address": "5815 Co Rd 41, Farmington, NY 14425, USA",
"Vendor_Address_Line": "5815 41",
"Vendor_Bank_Name": "",
"Vendor_Bank_Number": "",
"Vendor_City": "Farmington",
"Vendor_Company": "",
"Vendor_Name": "Global Point Technology USA",
"Vendor_Phone": "585-398-2000",
"Vendor_Recipient": "",
"Vendor_State": "NY",
"Vendor_Zipcode": "14425",
"photon_key": "data/app/20201005_142803_PDT_I1.json"
}
]
Field
Type
Description
Invoice_Number
string
Invoice number
PO_Number
string
Purchase Order number
Date
string <yyyy-MM-dd>
Document date as it appears in the document
Payment_Terms
string
Terms of payment, e.g., Net-30
Due_Date
string <yyyy-MM-dd>
Invoice due date
Currency_Code
string
Currency code, e.g., USD, EUR, CNY, etc.
Discount
decimal
Discount provided on the invoice or receipt
Vat_Number
string
The Value Added Tax number, e.g., 12-3456789
Total
decimal
Total of the invoice or receipt
The follow describes the complete fields and value types. For an example response, please see the above "Response" tab.
[
{
# invoice info
"Invoice_Number": "<invoice number>",
"PO_Number": "<purchase order>",
"Date": "<invoice date yyyy-MM-dd>",
"Payment_Terms": "<interpreted terms, e.g. Net-30>",
"Due_Date": "<invoice due date yyyy-MM-dd>",
"Currency_Code": "<currency code e.g. USD>",
"Discount": < decimal percent discount > ,
"Vat_Number": "<tax number e.g. 12‑3456789>",
# purchase info
"Total": <decimal dollar amount> ,
"Shipping": <decimal dollars found for shipping> ,
"Subtotal": <decimal pretax dollars subtotal>,
"Tax": <decimal dollars found for tax> ,
"Tip": <decimal dollars found for tip> ,
"Line_Items": [{
"Line": <integer incrementing counter> ,
"SKU": <parsed SKU code>,
"Description": <raw description>,
"QTY": <decimal number of units>,
"Unit": <unit of measure>,
"Price": <decimal unit price > ,
"Amount": <decimal total pricing>
}],
"Tracking_Number": "<shipment info>",
# recipient/payer info
"Account_Number": <payer account number>,
"Bill_To_Name": <payer company name>,
"Bill_To_Recipient": <payer name>,
"Bill_To_Address": <payer address>,
"Bill_To_Address_Line": <parsed payer address line 1>,
"Bill_To_City": <parsed payer city>,
"Bill_To_State": <parsed payer state>,
"Bill_To_Zipcode": <parsed payer postal code>,
"Card_Number": <payment credit card number if present>,
"Payment_Display_Name": <fulltext of payment card info if present e.g. ***9999>,
"Payment_Type": <inferred payment method e.g. Visa>,
# vendor info
"Vendor_Account_Number": <bank account number>,
"Vendor_Bank_Name": <Bank name for payment routing>,
"Vendor_Bank_Number": <Bank acct # for payment routing>,
"Vendor_Name": <invoice issuing vendor name>,
"Vendor_Address": <Full unparsed address of vendor company>,
"Vendor_Recipient": <personal name of the vendor>,
"Vendor_Address_Line": <parsed address line 1 and 2>,
"Vendor_City": <parsed city>,
"Vendor_State": <full state e.g. California or state code e.g. CA>,
"Vendor_Zipcode": <parsed postal code>,
"Vendor_Phone": <vendor phone number - raw>,
"Phone_Number": <payer phone number>,
"All_Email_Addresses": <comma-separated list of emails found in invoice>,
# Photon info
"Category": <interpretation of document type>,
"Raw_Text": <full parsed text>,
"Reference_Number": <internal photon ref #>,
"photon_key": <photon file location>
}
]
Last updated
Was this helpful?