API receives a lists: how to build a WF to separate them?

[marco1]

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

[marco1]

Anyone?
any help also small hints are very much welcome!
Thanks in advance for your help!

[NigelG]

https://buildingonbubble.com/block/save-a-repeating-group-1472016928237x990158512135602200

This might help ?

[marco1]

Thanks @NigelG,

but the editor is broken:
I do not have the rights to see it.

{“errorMessages”:[“Het geselecteerde filter is niet beschikbaar voor jou. Misschien is het verwijderd of zijn de rechten van het filter gewijzigd.”],“errors”:{}}

“The filter is nog available for you, maybe it is deleted of rights has been changed”

[NigelG]

Oh yes. It has been vandalised it seems.

Will find the links.

[marco1]

Hi @NigelG

Did you find the links?
Or anyone else?

thanks a lot for helping me!

[NigelG]

Yes, the link above has been updated.

[marco1]

Thanks! I will have a look very soon…

[marco1]

Sorry @NigelG,
I have tried to understand, but this is not clear for me…

Is there an option to send a request to the lab for the sample ID AND the TESTScode?
so that I only get the “repeating group” TESTS?

thanks for your (ore someone else) help!