interchange data to a json api. (1 Viewer)

nikoslantos

New member
Local time
Today, 07:31
Joined
Oct 6, 2021
Messages
7
Hi my name is nick.
and i need to interchange data ( edi invoices ) with a software provider named softone here in Greece.
My application is msaccess 2002 (mdb file) . Does any one can help me with this isue.
i can pay for this in logical price.
thank you.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:31
Joined
May 7, 2009
Messages
14,089
show your sample json file.
 

nikoslantos

New member
Local time
Today, 07:31
Joined
Oct 6, 2021
Messages
7
{
"Currency":"EURO",
"CurrencyCode":"EUR",
"InvoiceTypeCode":"1.1",
"DocumentType":"(72)Τιμολόγιο Δελτίο Αποστολής",
"DocumentTypeCode":"INVOICE",
"Series":"Γ",
"Number":"122233",
"DateIssued":"2021-10-05T10:32:41",
"Issuer":{
"RegisteredName":"ΜΟΥΡΚΑ Ι.Κ.Ε",
"Vat":"EL118058830",
"Activities":[
"SUPER MARKET"
],
"Phones":[
"2632024094"
],
"Address":{
"Country":"Greece",
"CountryCode":"GR",
"City":"ΥΠΟΚΑΤΑΣΤΗΜΑ ΑΙΤΩΛΙΚΟΥ",
"Street":"ΝΤΟΛΜΑ 4",
"Postal":"30400"
},
"TaxOffice":"ΜΕΣΟΛΟΓΓΙΟΥ"
},
"CounterParty":{
"RegisteredName":"ΕΣΤΙΑΤΟΡΙΟ ΠΑΠΑΓΡΗΓΟΡΑΤΟΣ",
"Vat":"EL048147244",
"Activities":[
"Εστιατοριο"
],
"Address":{
"CountryCode":"GR",
"Country":"Greece",
"City":"Missing",
"Street":"Missing",
"Postal":"30400"
}
},
"DistributionDetails":{
"InternalDocumentId":"Internal erp Code",
"MovePurpose":"ΠΩΛΗΣΗ",
"DeliveryDestinationDetails":{
"Address":{
"CountryCode":"GR",
"Country":"Greece",
"Street":"ΕΔΡΑ ΤΟΥΣ",
"Postal":"Missing",
"City":"Missing"
}
}
},
"PaymentDetails":{
"PaymentMethods":[
{
"PaymentMethodType":"ΜΕΤΡΗΤΟΙΣ",
"PaymentMethodTypeCode":3,
"Amount":19.65
}
]
},
"AdditionalDetails": {
"AccountingDepartmentEmails": [
"to_email_pou_tha_lavei_eidopoihsh@mail.com"
]
},
"Details":[
{
"Code":"5202453030626",
"Descriptions":[
"MR BREAKFAST ΔΗΜΗΤΡΙΑΚΑ RING HONEY 375G"
],
"MeasurementUnit":"ΤEM",
"Quantity":1,
"UnitPrice":1.58,
"NetTotal":1.58,
"Total":1.79,
"VATTotal":0.21,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":1.58
}
},
{
"Code":"9008695420425",
"Descriptions":[
"IGLO ΦΙΛΕΤΟ ΜΠΑΚΑΛΙΑΡΟΥ 240ΓΡ Σ8"
],
"MeasurementUnit":"τεμ",
"Quantity":1,
"UnitPrice":4.25,
"NetTotal":4.25,
"Total":4.8,
"VATTotal":0.55,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":4.25
}
},
{
"Code":"8001090026897",
"Descriptions":[
"LENOR ΜΑΛΑΚ 26 ΜΕΖ DIAMANTE K FIORI DI L"
],
"MeasurementUnit":"τεμ",
"Quantity":1,
"UnitPrice":2.73,
"NetTotal":2.73,
"Total":3.39,
"VATTotal":0.66,
"VatCategoryCode":1,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":2.73
}
},
{
"Code":"521034048401",
"Descriptions":[
"PUMMARO ΨΙΛΟΚΟΜΜΕΝΟ ΚΛΑΣΣΙΚΟ 400ΓΡ Χ24Τ"
],
"MeasurementUnit":"τεμ",
"Quantity":1,
"UnitPrice":0.69,
"NetTotal":0.69,
"Total":0.78,
"VATTotal":0.09,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":0.69
}
},
{
"Code":"5210113000964",
"Descriptions":[
"ΕΛΛ.ΜΑΡΚΕΤ ΣΑΚ.ΤΥΠΩΜ.35Χ35(40μικ)"
],
"MeasurementUnit":"ΚΙΛ",
"Quantity":2,
"UnitPrice":0.12,
"NetTotal":0.24,
"Total":0.3,
"VATTotal":0.06,
"VatCategoryCode":1,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":0.24
}
},
{
"Code":"5201013014618",
"Descriptions":[
"SYN ΖΥΜ.ΣΠΑΓΓΕΤΙ Νο10 500γρ σ24"
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":0.45,
"NetTotal":0.45,
"Total":0.51,
"VATTotal":0.06,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":0.45
}
},
{
"Code":"5201013014618",
"Descriptions":[
"SYN ΖΥΜ.ΣΠΑΓΓΕΤΙ Νο10 500γρ σ24"
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":0.45,
"NetTotal":0.45,
"Total":0.51,
"VATTotal":0.06,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":0.45
}
},
{
"Code":"5206783000489",
"Descriptions":[
"ΕΛ ΦΑΣΟΛΑΚΙ ΠΛΑΤΥ ΚΑΤΕΨ. 100ΓΡ Σ10"
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":1.95,
"NetTotal":1.95,
"Total":2.2,
"VATTotal":0.25,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":1.95
}
},
{
"Code":"5201168715217",
"Descriptions":[
"ΔΩΔΩΝΗ ΓΙΑΟΥΡΤΙ ΚΛΑΣΙΚΟ 1ΚΙΛ.2%Λ.ΠΛ.ΔΟΧ."
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":3,
"NetTotal":3,
"Total":3.39,
"VATTotal":0.39,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":3
}
},
{
"Code":"5204458016445",
"Descriptions":[
"ΕΛΟΜΑΣ ΤΥΡΟΠΙΤΑΚΙ 800ΓΡ Σ10"
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":1.76,
"NetTotal":1.76,
"Total":1.99,
"VATTotal":0.23,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":1.76
}
}
],
"VatAnalysis":[{
"Name":"24%",
"VatAmount":0.72,
"UnderlyingValue": 3.69,
"Percentage": 24
},
{
"Name":"13%",
"VatAmount":1.84,
"UnderlyingValue": 15.97,
"Percentage": 13
}],
"Summaries":{
"TotalNetAmount":17.1,
"TotalVATAmount":2.56,
"TotalGrossValue":19.66,
"TotalPayableAmount":19.66
}
}
 

nikoslantos

New member
Local time
Today, 07:31
Joined
Oct 6, 2021
Messages
7
i can create this data from my database as a json file .
But i don't know how can post it to provider wich have the api.
and then to get the mark of it.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:31
Joined
May 7, 2009
Messages
14,089
you need to communicate with softone on how
to use their api. and if ever possible to use vba.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:31
Joined
Oct 29, 2018
Messages
16,572
Hi Nick. Welcome to AWF!

Can you post a link to their API website?
 

Users who are viewing this thread

Top Bottom