Skip to main content

General

Script: Send FMData To QBO ( {Entity , FmID} )


Description

Send a FileMaker Record to QBO. The record will be looked up, packaged into JSON and sent to QBO

FileMaker Script Folder Path

/Application Modules/LedgerLink/LedgerLink API/Public/General/Send FMData To QBO ( {Entity , FmID} )

Parameters

TypeNameDescriptionOptionalDefault
objectparams
stringparams.Entitythe target Entity
stringparams.FmIdthe FileMaker record id

Success Return

[
{
"type": "object",
"name": "error",
"description": "",
"optional": false,
"default": ""
},
{
"type": "number",
"name": "error.errorCode",
"description": "= 0",
"optional": false,
"default": ""
}
]

Error Return

[
{
"type": "object",
"name": "error",
"description": "",
"optional": false,
"default": ""
},
{
"type": "number",
"name": "error.errorCode",
"description": "<> 0",
"optional": false,
"default": ""
}
]
Meta Data
  • Modification Count: 197
  • TimeStamp: 2020-05-25 23:36:55

Script: Save QBO Records To FM ( {Entity, Records )


Description

Takes an array of records and saves them to the Database. This is called by the sync engine when it is pulling records from QBO into FileMaker but it can be used on its own as well. The records will need to be in QBO's structure

FileMaker Script Folder Path

/Application Modules/LedgerLink/LedgerLink API/Public/General/Save QBO Records To FM ( {Entity, Records )

Parameters

TypeNameDescriptionOptionalDefault
objectparams
stringparams.Entitythe target Entity
arrayparams.Recordsan array of records to Save

Success Return

[
{
"type": "object",
"name": "error",
"description": "",
"optional": false,
"default": ""
},
{
"type": "number",
"name": "error.errorCode",
"description": "will be 0",
"optional": false,
"default": ""
}
]

Error Return

[
{
"type": "object",
"name": "error",
"description": "",
"optional": false,
"default": ""
},
{
"type": "number",
"name": "error.errorCode",
"description": "some non-zero number",
"optional": false,
"default": ""
}
]
Meta Data
  • Modification Count: 43
  • TimeStamp: 2020-06-05 14:05:46

Script: Save QBO Record To FM ( {Entity, Record )


Description

Takes a QBO Formatted record and saves it to the Database. This called by the sync engine when it is pulling records from QBO into FileMaker but it can be used on its own as well.

FileMaker Script Folder Path

/Application Modules/LedgerLink/LedgerLink API/Public/General/Save QBO Record To FM ( {Entity, Record )

Parameters

TypeNameDescriptionOptionalDefault
objectparams
stringparams.Entitythe target Entity
objectparams.Recorda json Record object

Success Return

[
{
"type": "object",
"name": "error",
"description": "",
"optional": false,
"default": ""
},
{
"type": "number",
"name": "error.errorCode",
"description": "will be 0",
"optional": false,
"default": ""
}
]

Error Return

[
{
"type": "object",
"name": "error",
"description": "",
"optional": false,
"default": ""
},
{
"type": "number",
"name": "error.errorCode",
"description": "some non-zero number",
"optional": false,
"default": ""
}
]
Meta Data
  • Modification Count: 103
  • TimeStamp: 2020-06-05 14:05:47

Script: Pull QBO Entity Into FM ({Entity ; FmId })


Description

Pulls a record from QBO and saves it to the Database. You can use this to "refresh" a record from QBO. uses the FileMaker Id to target the record to pull

FileMaker Script Folder Path

/Application Modules/LedgerLink/LedgerLink API/Public/General/Pull QBO Entity Into FM ({Entity ; FmId })

Parameters

TypeNameDescriptionOptionalDefault
objectparams
stringparams.Entitythe qbo Entity to pull
stringparams.FmIdthe FileMaker Primary Key

Success Return

none given

Error Return

none given

Meta Data
  • Modification Count: 33
  • TimeStamp: 2020-05-25 23:36:57

Script: Pull QBO Entity Into FileMaker ( {Entity, QBOId })


Description

Pulls a record from QBO and saves it to the Database. You can use this to "refresh" a record from QBO. uses the QBO Id to target the record

FileMaker Script Folder Path

/Application Modules/LedgerLink/LedgerLink API/Public/General/Pull QBO Entity Into FileMaker ( {Entity, QBOId })

Parameters

TypeNameDescriptionOptionalDefault
objectparams
stringparams.Entitythe qbo Entity to write
stringparams.QBOIdthe qbo Id to pull into Filemaker

Success Return

none given

Error Return

none given

Meta Data
  • Modification Count: 61
  • TimeStamp: 2020-05-25 23:36:54