• Andrew Bishop 10
  • NEWBIE
  • 0 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Has anyone ever connected their Salesforce org with Healthtouch? I'm looking to connect via API the Healthtouch platform and our org.
Hello,

My flow suddenly stopped working and when I went to debug the error the only thing that seems out of place is that when I am done assigning the sObj variables and I pass those values into the Collection Variable NO ID appears in the collection variable for the new services I am trying to create

The Flow's Lookup is functioning properly as well as the loop. But something happens when the final assignment takes the sOBJ variables and passes them to the final create sOBJ Collection variable called {Collection_Service_New}

Below is a screenshot of the flow and the debug log showing the first iteration of the flow

User-added image

How the Interview Started
Alex Waddell (0051N000005gBa1) started the flow interview.
Some of this flow's variables were set when the interview started.
varPayer = 0011N00001IC9YBQA1
varAuthFrom = January 1, 2019
varRegion = a0A1N00001K8s1EUAR
varAuthTo = January 31, 2019

FAST LOOKUP: lookup_Authorizations
Find all Authorization__c records where:
PERS_Status__c Equals On Service
PERS_Status__c Equals Termed
Valid_From__c Less than or equal {!varAuthTo} (January 31, 2019)
Valid_To__c Greater than or equal {!varAuthFrom} (January 1, 2019)
Payer__c Equals {!varPayer} (0011N00001IC9YBQA1)
RecordTypeId Equals 0121N0000019CFLQA2
Install_Date__c Is null false
Install_Date__c Less than or equal {!varAuthTo} (January 31, 2019)
Region__c Equals {!varRegion} (a0A1N00001K8s1EUAR)
Assign those records to {!Collection_Authorizations}.
Save these field values in the variable: Id, Modifier_Tax_Id__c, Modifier_NPI__c, ICD_10__c, Billing_Code__c, Payer__c, Price__c, Region__c, Service_Plan__c, First_Name__c, Last_Name__c, Medicaid_ID__c, Date_Of_Birth__c, Billing_Street__c, Billing_City__c, Billing_State_Code__c, Billing_Zip__c, Gender__c, Authorization_Number__c
Result
Successfully found records.

LOOP: loop_Through_Auths
Loop Through: [a0H1N00000LmlCuUAJ,a0H1N00000LmlDGUAZ,a0H1N00000LmlDLUAZ,a0H1N00000LmlDOUAZ,a0H1N00000LmlEBUAZ,a0H1N00000LmlEIUAZ,a0H1N00000LmlFwUAJ,a0H1N00000LmlHUUAZ,a0H1N00000LmlHYUAZ,a0H1N00000LmlHjUAJ,a0H1N00000LmlHpUAJ,a0H1N00000LmlHzUAJ,a0H1N00000LmlI4UAJ,a0H1N00000LmlI7UAJ,a0H1N00000LmlIFUAZ,a0H1N00000LmlIKUAZ,a0H1N00000LmlIOUAZ,a0H1N00000LmlIPUAZ,a0H1N00000LmlIUUAZ,a0H1N00000LmlIoUAJ,a0H1N00000LmlIpUAJ,a0H1N00000LmlIrUAJ,a0H1N00000LmlIuUAJ,a0H1N00000LmlIyUAJ,a0H1N00000LmlIzUAJ,a0H1N00000LmlJ0UAJ,a0H1N00000LmlJ1UAJ,a0H1N00000LmlJDUAZ,a0H1N00000LmlJFUAZ,a0H1N00000LmlJMUAZ,a0H1N00000LmlJNUAZ,a0H1N00000LmlJTUAZ,a0H1N00000LmlJUUAZ,a0H1N00000LmlJYUAZ,a0H1N00000LmlK5UAJ,a0H1N00000LmlKFUAZ,a0H1N00000LmlKIUAZ,a0H1N00000LmlKMUAZ,a0H1N00000LmlKNUAZ,a0H1N00000LmlKbUAJ,a0H1N00000LmlL0UAJ,a0H1N00000LmlL7UAJ,a0H1N00000LmlLAUAZ,a0H1N00000LmlLBUAZ,a0H1N00000LmlLGUAZ,a0H1N00000LmlLNUAZ,a0H1N00000LmlLSUAZ,a0H1N00000LmlLgUAJ,a0H1N00000LmlLrUAJ,a0H1N00000LmlLyUAJ,a0H1N00000LmlM7UAJ,a0H1N00000LmlMMUAZ,a0H1N00000LmlMSUAZ,a0H1N00000LmlMaUAJ,a0H1N00000LmlMiUAJ,a0H1N00000LmlMqUAJ,a0H1N00000LmlN8UAJ,a0H1N00000LmlNIUAZ,a0H1N00000LmlNMUAZ,a0H1N00000LmlNPUAZ,a0H1N00000LmlNQUAZ,a0H1N00000LmlNXUAZ,a0H1N00000LmlNZUAZ,a0H1N00000LmlNrUAJ,a0H1N00000LmlOlUAJ,a0H1N00000LmlOvUAJ,a0H1N00000LmlPBUAZ,a0H1N00000LmlPGUAZ,a0H1N00000LmlPLUAZ,a0H1N00000LmlQyUAJ,a0H1N00000LmlQzUAJ,a0H1N00000LmlUvUAJ,a0H1N00000LmlV3UAJ,a0H1N00000LmlV5UAJ,a0H1N00000LmlV7UAJ,a0H1N00000LmlVsUAJ,a0H1N00000LmlVxUAJ,a0H1N00000LmlW2UAJ,a0H1N00000LmlWEUAZ,a0H1N00000LmlWQUAZ,a0H1N00000LmlWlUAJ,a0H1N00000LmlXTUAZ,a0H1N00000LmlXUUAZ,a0H1N00000LmlagUAB,a0H1N00000LmlbrUAB,a0H1N00000Lmlc0UAB,a0H1N00000LmlcwUAB,a0H1N00000Lmld0UAB,a0H1N00000Lmld1UAB,a0H1N00000Lmld4UAB,a0H1N00000Lmld5UAB,a0H1N00000Lmld6UAB,a0H1N00000Lmld7UAB,a0H1N00000Lmld9UAB,a0H1N00000LmldFUAR,a0H1N00000LmldJUAR,a0H1N00000LmldSUAR,a0H1N00000LmldaUAB,a0H1N00000LmleLUAR,a0H1N00000LmlgFUAR,a0H1N00000LmlgJUAR,a0H1N00000LmlgNUAR,a0H1N00000LmlgRUAR,a0H1N00000LmlgYUAR,a0H1N00000LmlgaUAB,a0H1N00000LmlgcUAB,a0H1N00000LmlggUAB,a0H1N00000LmlghUAB,a0H1N00000Lmlh9UAB,a0H1N00000LmlhNUAR,a0H1N00000LmlhOUAR,a0H1N00000LmlhSUAR,a0H1N00000LmlhiUAB,a0H1N00000Lmli4UAB,a0H1N00000Lmli9UAB,a0H1N00000LmliAUAR,a0H1N00000LmlicUAB,a0H1N00000LmliuUAB,a0H1N00000Lmlj0UAB,a0H1N00000LmljZUAR,a0H1N00000LmljhUAB,a0H1N00000LmljjUAB,a0H1N00000LmljlUAB,a0H1N00000LmljwUAB,a0H1N00000LmlkkUAB,a0H1N00000Lmll6UAB,a0H1N00000LmllKUAR,a0H1N00000Lmlm9UAB,a0H1N00000LmlmAUAR,a0H1N00000LmlmBUAR,a0H1N00000LmlmFUAR,a0H1N00000LmlmGUAR,a0H1N00000LmlmIUAR,a0H1N00000LmlmKUAR,a0H1N00000LmlmLUAR,a0H1N00000LmlmMUAR,a0H1N00000LmlmQUAR,a0H1N00000LmlmWUAR,a0H1N00000LmlmdUAB,a0H1N00000LmlmmUAB,a0H1N00000Lmln8UAB,a0H1N00000LmlnYUAR,a0H1N00000LmlnkUAB,a0H1N00000LmloDUAR,a0H1N00000LmloaUAB,a0H1N00000LmlohUAB,a0H1N00000LmloiUAB,a0H1N00000LmlokUAB,a0H1N00000LmlosUAB,a0H1N00000LmlpKUAR,a0H1N00000LmlpNUAR,a0H1N00000LmlpRUAR,a0H1N00000LmlqAUAR,a0H1N00000LmlqBUAR,a0H1N00000LmlqGUAR,a0H1N00000LmlqmUAB,a0H1N00000LmlqrUAB,a0H1N00000Lmlr4UAB,a0H1N00000Lmlr7UAB,a0H1N00000LmlrCUAR,a0H1N00000LmlrQUAR,a0H1N00000LmlujUAB,a0H1N00000LmlukUAB,a0H1N00000LmlunUAB,a0H1N00000Lmlv3UAB,a0H1N00000LmlvcUAB,a0H1N00000LmlvmUAB,a0H1N00000LmlvwUAB,a0H1N00000Lmlw4UAB,a0H1N00000Lmlw5UAB,a0H1N00000LmlwGUAR,a0H1N00000LmlwIUAR,a0H1N00000LmlwQUAR,a0H1N00000LmlwUUAR,a0H1N00000LmlwaUAB,a0H1N00000LmlwnUAB,a0H1N00000LmlwqUAB,a0H1N00000Lmlx2UAB,a0H1N00000LmlxNUAR,a0H1N00000LmlxYUAR,a0H1N00000LmlxZUAR,a0H1N00000LmlxcUAB,a0H1N00000LmlxjUAB,a0H1N00000Lmm1eUAB,a0H1N00000Lmm2vUAB,a0H1N00000Lmm3dUAB,a0H1N00000Lmm3zUAB,a0H1N00000Lmm40UAB,a0H1N00000Lmm4AUAR,a0H1N00000Lmm4UUAR,a0H1N00000Lmm4WUAR,a0H1N00000Lmm4dUAB,a0H1N00000Lmm4oUAB,a0H1N00000Lmm4qUAB,a0H1N00000Lmm4rUAB,a0H1N00000Lmm4sUAB,a0H1N00000Lmm5CUAR,a0H1N00000Lmm5EUAR,a0H1N00000Lmm5FUAR,a0H1N00000Lmm5IUAR,a0H1N00000Lmm5JUAR,a0H1N00000Lmm5KUAR,a0H1N00000Lmm5MUAR,a0H1N00000Lmm5UUAR,a0H1N00000Lmm5VUAR,a0H1N00000Lmm5WUAR,a0H1N00000Lmm5eUAB,a0H1N00000Lmm5uUAB,a0H1N00000Lmm6FUAR,a0H1N00000Lmm6IUAR,a0H1N00000Lmm6OUAR,a0H1N00000Lmm6aUAB,a0H1N00000Lmm6bUAB,a0H1N00000Lmm6dUAB,a0H1N00000Lmm6fUAB,a0H1N00000Lmm6hUAB,a0H1N00000Lmm6iUAB,a0H1N00000Lmm6qUAB,a0H1N00000Lmm6wUAB,a0H1N00000Lmm6yUAB,a0H1N00000Lmm74UAB,a0H1N00000Lmm7BUAR,a0H1N00000Lmm7CUAR,a0H1N00000Lmm7DUAR,a0H1N00000Lmm7OUAR,a0H1N00000Lmm7QUAR,a0H1N00000Lmm7TUAR,a0H1N00000Lmm7yUAB,a0H1N00000Lmm7zUAB,a0H1N00000Lmm86UAB,a0H1N00000Lmm89UAB,a0H1N00000Lmm8AUAR,a0H1N00000Lmm8GUAR,a0H1N00000Lmm8HUAR,a0H1N00000Lmm8RUAR,a0H1N00000Lmm8qUAB,a0H1N00000Lmm8tUAB,a0H1N00000Lmm8zUAB,a0H1N00000Lmm9HUAR,a0H1N00000Lmm9IUAR,a0H1N00000Lmm9JUAR,a0H1N00000Lmm9KUAR,a0H1N00000Lmm9LUAR,a0H1N00000Lmm9QUAR,a0H1N00000Lmm9UUAR,a0H1N00000LmmA5UAJ,a0H1N00000LmmAKUAZ,a0H1N00000LmmALUAZ,a0H1N00000LmmAMUAZ,a0H1N00000LmmANUAZ,a0H1N00000LmmASUAZ,a0H1N00000LmmAeUAJ,a0H1N00000LmmAoUAJ,a0H1N00000LmmApUAJ,a0H1N00000LmmAyUAJ,a0H1N00000LmmAzUAJ,a0H1N00000LmmB0UAJ,a0H1N00000LmmB5UAJ,a0H1N00000LmmB8UAJ,a0H1N00000LmmBCUAZ,a0H1N00000LmmBKUAZ,a0H1N00000LmmCCUAZ,a0H1N00000LmmCDUAZ,a0H1N00000LmmCTUAZ,a0H1N00000LmmCUUAZ,a0H1N00000LmmCVUAZ,a0H1N00000LmmCWUAZ,a0H1N00000LmmCXUAZ,a0H1N00000LmmCYUAZ,a0H1N00000LmmCaUAJ,a0H1N00000LmmCbUAJ,a0H1N00000LmmCcUAJ,a0H1N00000LmmCdUAJ,a0H1N00000LmmCeUAJ,a0H1N00000LmmCoUAJ,a0H1N00000LmmCpUAJ,a0H1N00000LmmCqUAJ,a0H1N00000LmmCrUAJ,a0H1N00000LmmCvUAJ,a0H1N00000LmmDAUAZ,a0H1N00000LmmDGUAZ,a0H1N00000LmmDIUAZ,a0H1N00000LmmDLUAZ,a0H1N00000LmmDNUAZ,a0H1N00000LmmDQUAZ,a0H1N00000LmmDRUAZ,a0H1N00000LmmDjUAJ,a0H1N00000LmmE4UAJ,a0H1N00000LmmEXUAZ,a0H1N00000LmmEuUAJ,a0H1N00000LmmFgUAJ,a0H1N00000LmmFhUAJ,a0H1N00000LmmFoUAJ,a0H1N00000LmmFpUAJ,a0H1N00000LmmFqUAJ,a0H1N00000LmmFvUAJ,a0H1N00000LmmFwUAJ,a0H1N00000LmmFxUAJ,a0H1N00000MJprBUAT,a0H1N00000MJprkUAD,a0H1N00000MJsxvUAD,a0H1N00000MKBs2UAH,a0H1N00000MKS8KUAX,a0H1N00000MKU9nUAH,a0H1N00000MKUACUA5,a0H1N00000MKUC3UAP,a0H1N00000NU1F8UAL,a0H1N00000NU1HYUA1,a0H1N00000NU1HnUAL,a0H1N00000NU1MDUA1,a0H1N00000NU1N1UAL,a0H1N00000NV7AXUA1,a0H1N00000NV7CvUAL,a0H1N00000NV7E8UAL,a0H1N00000NV7ESUA1,a0H1N00000NV7FVUA1,a0H1N00000NV7FaUAL,a0H1N00000NV7G9UAL,a0H1N00000NV7HEUA1,a0H1N00000NVxXYUA1,a0H1N00000NW5mQUAT,a0H1N00000NW5niUAD,a0H1N00000NW5o7UAD,a0H1N00000NW5ogUAD,a0H1N00000NW5qCUAT,a0H1N00000NW5qWUAT,a0H1N00000NW5quUAD,a0H1N00000NW5qzUAD,a0H1N00000NW5rJUAT,a0H1N00000NW5riUAD,a0H1N00000NW5sRUAT,a0H1N00000NW5woUAD,a0H1N00000NW8HvUAL,a0H1N00000NW8HwUAL,a0H1N00000NWBAZUA5,a0H1N00000NbIIZUA3,a0H1N00000Nbc4SUAR,a0H1N00000Np6PKUAZ,a0H1N00000NptruUAB,a0H1N00000NpwBGUAZ,a0H1N00000Npz38UAB,a0H1N00000Nq04EUAR,a0H1N00000Nq8zPUAR,a0H1N00000NqZf4UAF,a0H1N00000NqZoeUAF,a0H1N00000NqZrOUAV,a0H1N00000NqZt7UAF,a0H1N00000NqZuPUAV,a0H1N00000NqZvSUAV,a0H1N00000NqZwLUAV,a0H1N00000NqZyAUAV,a0H1N00000NrLfOUAV,a0H1N00000NrLh5UAF,a0H1N00000NrLhyUAF,a0H1N00000NrLiSUAV,a0H1N00000NrLj6UAF,a0H1N00000NrLkTUAV,a0H1N00000NrLlmUAF,a0H1N00000NrLn4UAF,a0H1N00000NrRE2UAN,a0H1N00000NrRnOUAV,a0H1N00000NrRtoUAF,a0H1N00000NrRv1UAF,a0H1N00000NrRwJUAV,a0H1N00000NrRwTUAV,a0H1N00000NrS0PUAV,a0H1N00000NrS3dUAF,a0H1N00000NrV5uUAF,a0H1N00000NrV9EUAV,a0H1N00000NrVB0UAN,a0H1N00000NrVBUUA3,a0H1N00000NrVL6UAN,a0H1N00000NrVMOUA3,a0H1N00000NrazYUAR,a0H1N00000Nrb0qUAB,a0H1N00000NrhiIUAR,a0H1N00000NrhnjUAB,a0H1N00000NrhpPUAR,a0H1N00000NrkuBUAR,a0H1N00000Nrx7HUAR,a0H1N00000NrxQ1UAJ,a0H1N00000Ns0LFUAZ,a0H1N00000Ns4gRUAR,a0H1N00000NsMCCUA3,a0H1N00000Nspn3UAB,a0H1N00000Nstx3UAB,a0H1N00000Nsu0qUAB,a0H1N00000Nt7heUAB,a0H1N00000OZId9UAH,a0H1N00000OZPRJUA5,a0H1N00000OZh2BUAT]
Iteration: 0
Current value of {!Collected_Authorizations}: a0H1N00000LmlCuUAJ

ASSIGNMENT: assign_Service_fields
{!sOBJ_Services.Service_Plan__c} Equals {!Collected_Authorizations.Service_Plan__c}
{!sOBJ_Services.ICD_10_Code__c} Equals {!Collected_Authorizations.ICD_10__c}
{!sOBJ_Services.Price__c} Equals {!Collected_Authorizations.Price__c}
{!sOBJ_Services.Payer__c} Equals {!Collected_Authorizations.Payer__c}
{!sOBJ_Services.Billing_Code__c} Equals {!Collected_Authorizations.Billing_Code__c}
{!sOBJ_Services.Modifier_NPI__c} Equals {!Collected_Authorizations.Modifier_NPI__c}
{!sOBJ_Services.Modifier_Tax_Id__c} Equals {!Collected_Authorizations.Modifier_Tax_Id__c}
{!sOBJ_Services.Region__c} Equals {!varRegion}
{!sOBJ_Services.Monthly_Billing__c} Equals {!varRecordId}
{!sOBJ_Services.Billing_Month__c} Equals {!varAuthTo}
{!sOBJ_Services.Billing_Medicaid_ID__c} Equals {!Collected_Authorizations.Medicaid_ID__c}
{!sOBJ_Services.First_Name__c} Equals {!Collected_Authorizations.First_Name__c}
{!sOBJ_Services.Last_Name__c} Equals {!Collected_Authorizations.Last_Name__c}
{!sOBJ_Services.Date_of_Birth__c} Equals {!Collected_Authorizations.Date_Of_Birth__c}
{!sOBJ_Services.Billing_Street__c} Equals {!Collected_Authorizations.Billing_Street__c}
{!sOBJ_Services.Billing_City__c} Equals {!Collected_Authorizations.Billing_City__c}
{!sOBJ_Services.Billing_State_Code__c} Equals {!Collected_Authorizations.Billing_State_Code__c}
{!sOBJ_Services.Billing_Zip__c} Equals {!Collected_Authorizations.Billing_Zip__c}
{!sOBJ_Services.Gender__c} Equals {!Collected_Authorizations.Gender__c}
{!sOBJ_Services.Authorization_Number__c} Equals {!Collected_Authorizations.Authorization_Number__c}
{!sOBJ_Services.Authorization__c} Equals {!Collected_Authorizations.Id}

I have blacked out data relating to our patients. but you can trust me that there is data in all of those fields
User-added image
ASSIGNMENT: update_the_collection
{!Collection_Service_New} Add {!sOBJ_Services}
Result
{!Collection_Service_New} = "[Services__c (No ID)]"

Any Ideas on what can be causing this error?