Whats the preferred way to consume and export JSON Based files in Landmark. Would IPA be feasible or would we have to go to ION? Trying to import invoices and export payments via JSON.
We have certainly used IPA for JSON import and export. I don't believe I've personally used it for the two particular examples you are trying, but I don't see why you couldn't.
Could you share an example? We are trying to do API based calls and receiving and sending data in JSON format.
I haven't done that through API, just JSON files. My apologies.
I'm assuming you are defining a user business class to hold the contents of the JSON files. For fields whose type is JSONObject you can, in LPL, use the select type operator. See pages 15 and 19 of the current LPL Configuration guide.
select
If you look at the delivered LPL for the ThirdPartyApplication business class, for example, you'll see this kind of code in the Create Action (indenting removed to fit better in this forum):
Create Action
Name = JSONResult select "$.oauth_client.name"OAuthKey = JSONResult select "$.oauth_client.client_id"OAuthSecretTemp = JSONResult select "$.oauth_client.client_secret"