I have an API question
I succeed to get the data from the API into my app see also: API dynamic data problem - #13 by marco1
BUT… some of the fields are “list” fields and I need the create a database row containing alle first items and than create a second row containing all second items and so on…
I’m looking for a row containing: (see screenshot)
Row x: TPGC, TPAC, TPN, TP LOQ, TP Value, TP Ltype (MRL-EU), TP LValue, Ltype (ARFD-NL), TP LValue,
something like:
Row 1: 7300A169, , Captan, 0.01, 0.083, MRL-EU, 10, ARFD-NL, 0
Row 2: 7300A495, Q, Dithianon, 0.01, 0.034, MRL-EU, 3, ARFD-NL, 0
If all response gives the same number of items for all list fields I can split on item numbers.
Problem is that they are NOT all containing the same number of items.
Is there a way to to handle this?
Here is my API request workflow:
and here the API:
This is the XML of the data that is send to Bubble:
<?xml version="1.0"?> <EuroFins.Common.Schema.Result._14.sample> <analyticalReportCode>string</analyticalReportCode> <batchCode>string</batchCode> <sampleCode>string</sampleCode> <clientSampleCode>string</clientSampleCode> <sampleCustomerReference>string</sampleCustomerReference> <customerOrderCode>string</customerOrderCode> <orderingSampleKey>string</orderingSampleKey> <isoLanguageCode>string</isoLanguageCode> <receptionDate>string</receptionDate> <startAnalysisDate>string</startAnalysisDate> <validationDate>string</validationDate> <sampleStatus>string</sampleStatus> <assessment>string</assessment> <conclusion>string</conclusion> <laboratoryCode>string</laboratoryCode> <contractCode>string</contractCode> <senderClientCode>string</senderClientCode> <signatoryCode>string</signatoryCode> <analyticalReportStatusCode>string</analyticalReportStatusCode> <analyticalReportDocumentKey>string</analyticalReportDocumentKey> <clientSamples> <clientCode>string</clientCode> </clientSamples> <additionalElements> <name>string</name> <stringValue>string</stringValue> <typeCode>string</typeCode> </additionalElements> <tests> <testCode>string</testCode> <fractionCode>string</fractionCode> <fractionName>string</fractionName> <laboratoryCode>string</laboratoryCode> <method>string</method> <parameters> <parameterCode>string</parameterCode> <parameterName>string</parameterName> <lod>1.1</lod> <lodSpecified>true</lodSpecified> <loq>1.1</loq> <loqSpecified>true</loqSpecified> <accreditationCode>string</accreditationCode> <parameterGroupCode>string</parameterGroupCode> <result> <stringValue>string</stringValue> <numericalValue>string</numericalValue> <numericalValueUnit>string</numericalValueUnit> <unit>string</unit> <uncertainty>string</uncertainty> <comment>string</comment> <assessment>string</assessment> </result> <lineOrder>1.1</lineOrder> <lineOrderSpecified>true</lineOrderSpecified> <limits> <value>string</value> <unit>string</unit> <typeOfLimit>string</typeOfLimit> </limits> </parameters> <status>string</status> </tests> </EuroFins.Common.Schema.Result._14.sample>
These are my options in bubble:
and within Tests:
I really hope someone can help me with the last part of the puzzle!
thanks a lot for your time and help!
Marco