Parsed Json data dosen't work

[StefanHult]

I am playing arond with Langflow to see if I can connect it to a API for a Business system.
I use the API request, and in this case to get customers, it works fine.

The problem is when I run the data through the Parser. I get an error "Key error 'number'".

The template is used, and I have added there "Number: {number} , Name: {name}".
Just to name, leave the template blank, nothing happens and is most likely also what should happen.

I hacked the code a bit and got it working, but as soon as I want to get data from a nested object, it stops working again.

Any code on stock, that gets round the problem?

Data from the API Request looks like this, and this example is a single customer but I get the same error when sending in a list of customers.:

{"internalId":"144286","number":"10006","name":"Hennes & Mauritz Göteborg","status":"Active","mainAddress":{"addressId":"2563384","addressLine1":"","postalCode":"x5454","city":"Stockholm","country":{"id":"SE","name":"SVERIGE"}},"mainContact":{"contactId":"206526","name":"Hennes & Mauritz Göteborg"},"parentRecord":{"number":"10004","name":"Hennes & Mauritz Stockholm"},"consolidateInvoices":"True","customerClass":{"id":"10","description":"Svenska kunder"},"creditTerms":{"id":"30","description":"30 dagar"},"currencyId":"SEK","creditVerification":"Disabled","creditLimit":"0.0","creditDaysPastDue":"0","invoiceAddress":{"addressId":"2563384","addressLine1":"","postalCode":"x5454","city":"Stockholm","country":{"id":"SE","name":"SVERIGE"}},"invoiceContact":{"contactId":"206526","name":"Hennes & Mauritz Göteborg"},"printInvoices":"False","acceptAutoInvoices":"False","sendInvoicesByEmail":"False","printStatements":"False","sendStatementsByEmail":"False","printMultiCurrencyStatements":"False","statementType":"OpenItem","deliveryAddress":{"addressId":"2563384","addressLine1":"","postalCode":"x5454","city":"Stockholm","country":{"id":"SE","name":"SVERIGE"}},"deliveryContact":{"contactId":"206526","name":"Hennes & Mauritz Göteborg"},"vatZone":{"id":"01","description":"Inhemsk"},"location":{"countryId":"SE","id":"Main","name":"Primary location"},"attributes":[],"lastModifiedDateTime":"2024-12-23T08:00:42.773","createdDateTime":"2024-09-27T11:13:29.483","glAccounts":{"customerLedgerAccount":{"type":"A","number":"1510","description":"Kundfordringar"},"customerLedgerSubaccount":{"subaccountNumber":"000000000","subaccountId":"2706981","description":"Ingen","lastModifiedDateTime":"2024-02-06T22:01:05.463","active":"True","segments":[{"segmentId":"1","segmentDescription":"Running number","segmentValue":"00000","segmentValueDescription":"Ingen"},{"segmentId":"2","segmentDescription":"Year and month","segmentValue":"0000","segmentValueDescription":"Ingen"}]},"salesAccount":{"type":"I","number":"3031","description":"Försäljning varor, Sverige 25% moms"},"salesNonTaxableAccount":{"type":"I","number":"3034","description":"Försäljning varor, Sverige momsfri"},"salesSubaccount":{"subaccountNumber":"000000000","subaccountId":"2706981","description":"Ingen","lastModifiedDateTime":"2024-02-06T22:01:05.463","active":"True","segments":[{"segmentId":"1","segmentDescription":"Running number","segmentValue":"00000","segmentValueDescription":"Ingen"},{"segmentId":"2","segmentDescription":"Year and month","segmentValue":"0000","segmentValueDescription":"Ingen"}]},"cashDiscountAccount":{"type":"I","number":"3720","description":"Lämnade rabatter"},"cashDiscountSubaccount":{"subaccountNumber":"000000000","subaccountId":"2706981","description":"Ingen","lastModifiedDateTime":"2024-02-06T22:01:05.463","active":"True","segments":[{"segmentId":"1","segmentDescription":"Running number","segmentValue":"00000","segmentValueDescription":"Ingen"},{"segmentId":"2","segmentDescription":"Year and month","segmentValue":"0000","segmentValueDescription":"Ingen"}]},"prepaymentAccount":{"type":"L","number":"2420","description":"Förskott från kunder"},"prepaymentSubaccount":{"subaccountNumber":"000000000","subaccountId":"2706981","description":"Ingen","lastModifiedDateTime":"2024-02-06T22:01:05.463","active":"True","segments":[{"segmentId":"1","segmentDescription":"Running number","segmentValue":"00000","segmentValueDescription":"Ingen"},{"segmentId":"2","segmentDescription":"Year and month","segmentValue":"0000","segmentValueDescription":"Ingen"}]}},"invoiceToDefaultLocation":"True","paymentMethods":[],"defaultPaymentMethodId":"01","excludeDebtCollection":"False"}

[dosubot[bot]]

Hello @StefanHult! I'm here to assist you with any bugs, questions, or contributions you have. Let's figure this out together!

The error you're encountering, "Key error 'number'," suggests that the Parser component is unable to find the 'number' key in the JSON data. This could be due to the way the JSON is being parsed or how the JQ query is structured.

Here are a few suggestions to address the issue:

1. Verify JSON Structure: Ensure that the JSON data is being parsed correctly and that the 'number' key is accessible at the expected level. Since your JSON data is nested, you might need to adjust your JQ query to correctly navigate to the 'number' key.

2. JQ Query Adjustment: If you're using a JQ query to extract data, make sure it correctly targets the 'number' key. For example, if 'number' is nested within another object, your query should reflect that path.

3. Template Adjustment: If the template is causing issues, try simplifying it to isolate the problem. Start with a basic template and gradually add complexity to identify where it breaks.

4. Error Handling: Consider adding error handling in your code to catch and log missing keys, which can help in debugging the issue.

5. Test with Simplified Data: Test the Parser with a simplified version of your JSON data to ensure that the basic functionality works. Gradually introduce complexity to identify where the problem arises.

If these steps don't resolve the issue, you might need to review the specific implementation of the Parser component to ensure it aligns with your data structure and requirements.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[StefanHult]

The "number" key is in the root. How should the template be written in that case?